DAL/system/TCWL_D_User.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace DAL.system
{
    using Common;
    using Model.common;
    using System;
    using System.Collections;
    using System.Data;
    using System.Data.SqlClient;
    using System.Runtime.InteropServices;
    using System.Text;

    public class TCWL_D_User
    {
        public string addUser(TCWL_M_UserInfo u)
        {
            try
            {
                DBHelper.ExecuteSQL(string.Format("insert into TCWL_User(userXM,belongRole,phone,address,sex,pos,state,Activation,belongDeparment,userName,userMM,Email,header,bindPhone,bindFlag) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')", new object[] { u.userXM, u.belongRole, u.phone, u.address, u.sex, u.pos, u.state, u.Activation, u.belongDeparment, u.userName, u.userMM, u.Email, u.header, u.bindPhone, u.bindFlag }));
                return "success";
            }
            catch (Exception)
            {
                return "error";
            }
        }

        public string bindPhone(string bindUserId, string phone, string bindflag, string serviceid)
        {
            string sqlString = string.Format("update TCWL_User set bindPhone='{0}' , bindFlag='{1}' where serviceID='{2}' and userName='{3}' ", new object[] { phone, bindflag, serviceid, bindUserId });
            try
            {
                if (DBHelper.ExecuteSQL(sqlString) > 0)
                {
                    return "success";
                }
                return "nobindinf";
            }
            catch (Exception)
            {
                return "error";
            }
        }

        public string bindPhoneCheck(string userid, string phone, string bindflag)
        {
            if (DBHelper.GetDataTable(string.Format("select userName from TCWL_User where userName<>'{0}' and bindPhone='{1}'  and  bindFlag='{2}' ", userid, phone, bindflag)).Rows.Count > 0)
            {
                return "exist";
            }
            if (DBHelper.GetDataTable(string.Format("select userName from TCWL_User where userName='{0}'  and  bindFlag='{1}' ", userid, bindflag)).Rows.Count > 0)
            {
                return "have";
            }
            return "pass";
        }

        public bool CheckEmail(string name, string email)
        {
            bool flag2;
            try