예제 #1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public BWJS.Model.Users GetModel(int UserID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select * from Users ");
            strSql.Append(" where UserID=@UserID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UserID", SqlDbType.Int, 4)
            };
            parameters[0].Value = UserID;


            BWJS.Model.Users model = new BWJS.Model.Users();
            DataSet          ds    = BWJSHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
예제 #2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool UpdateDepartmentID(BWJS.Model.Users model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Users set ");
            strSql.Append(" DepartmentID = @DepartmentID , ");
            strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , ");
            strSql.Append(" RecordIsDelete = @RecordIsDelete , ");
            strSql.Append(" RecordUpdateTime = @RecordUpdateTime  ");
            strSql.Append(" where UserID=@UserID;");
            strSql.Append(@" UPDATE MofangDB.dbo.OrderApply SET DepartmentID = @DepartmentID  WHERE ((DepartmentID = NULL) or (DepartmentID=0)) AND UserID = @UserID  AND RecordIsDelete = 0 ;  ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UserID",             model.UserID),
                new SqlParameter("@DepartmentID",       model.DepartmentID),
                new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID),
                new SqlParameter("@RecordIsDelete",     model.RecordIsDelete),
                new SqlParameter("@RecordUpdateTime",   model.RecordUpdateTime)
            };

            int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(BWJS.Model.Users model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Users(");
            strSql.Append("UserType,GravatarResourceID,LastAccessIP,CompanyName,CreatUserID,RecordUpdateUserID,RecordIsDelete,RecordUpdateTime,RecordCreateTime,CardID,LoginName,ReginId,IsLocked,IsLogined,LoginTimes,ProvinceID,CityID,CountyID,Address,Password,UserName,Sex,Phone,QQ,Wechat,Email,DepartmentID,SId");
            strSql.Append(") values (");
            strSql.Append("@UserType,@GravatarResourceID,@LastAccessIP,@CompanyName,@CreatUserID,@RecordUpdateUserID,@RecordIsDelete,@RecordUpdateTime,@RecordCreateTime,@CardID,@LoginName,@ReginId,@IsLocked,@IsLogined,@LoginTimes,@ProvinceID,@CityID,@CountyID,@Address,@Password,@UserName,@Sex,@Phone,@QQ,@Wechat,@Email,@DepartmentID,@SId");
            strSql.Append(") ");
            strSql.Append(";select SCOPE_IDENTITY()");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UserType",           model.UserType),
                new SqlParameter("@GravatarResourceID", model.GravatarResourceID),
                new SqlParameter("@LastAccessIP",       model.LastAccessIP),
                new SqlParameter("@CompanyName",        model.CompanyName),
                new SqlParameter("@CreatUserID",        model.CreatUserID),
                new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID),
                new SqlParameter("@RecordIsDelete",     model.RecordIsDelete),
                new SqlParameter("@RecordUpdateTime",   model.RecordUpdateTime),
                new SqlParameter("@RecordCreateTime",   model.RecordCreateTime),
                new SqlParameter("@CardID",             model.CardID),
                new SqlParameter("@LoginName",          model.LoginName),
                new SqlParameter("@ReginId",            model.ReginId),
                new SqlParameter("@IsLocked",           model.IsLocked),
                new SqlParameter("@IsLogined",          model.IsLogined),
                new SqlParameter("@LoginTimes",         model.LoginTimes),
                new SqlParameter("@ProvinceID",         model.ProvinceID),
                new SqlParameter("@CityID",             model.CityID),
                new SqlParameter("@CountyID",           model.CountyID),
                new SqlParameter("@Address",            model.Address),
                new SqlParameter("@Password",           model.Password),
                new SqlParameter("@UserName",           model.UserName),
                new SqlParameter("@Sex",                model.Sex),
                new SqlParameter("@Phone",              model.Phone),
                new SqlParameter("@QQ",                 model.QQ),
                new SqlParameter("@Wechat",             model.Wechat),
                new SqlParameter("@Email",              model.Email),
                new SqlParameter("@DepartmentID",       model.DepartmentID),
                new SqlParameter("@SId",                model.SId)
            };


            object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
예제 #4
0
        public Users GetModelBySId(int sId)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 * from Users ");
            strSql.Append(" where SId=@sId and RecordIsDelete=0");
            SqlParameter[] parameters =
            {
                new SqlParameter("@sId", SqlDbType.Int, 4)
            };
            parameters[0].Value = sId;
            BWJS.Model.Users model = new BWJS.Model.Users();
            DataSet          ds    = BWJSHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
예제 #5
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(BWJS.Model.Users model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Users set ");
            strSql.Append(" UserType = @UserType , ");
            strSql.Append(" GravatarResourceID = @GravatarResourceID , ");
            strSql.Append(" LastAccessIP = @LastAccessIP , ");
            strSql.Append(" CompanyName = @CompanyName , ");
            strSql.Append(" CreatUserID = @CreatUserID , ");
            strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , ");
            strSql.Append(" RecordIsDelete = @RecordIsDelete , ");
            strSql.Append(" RecordUpdateTime = @RecordUpdateTime , ");
            strSql.Append(" RecordCreateTime = @RecordCreateTime , ");
            strSql.Append(" CardID = @CardID , ");
            strSql.Append(" LoginName = @LoginName , ");
            strSql.Append(" ReginId = @ReginId , ");
            strSql.Append(" IsLocked = @IsLocked , ");
            strSql.Append(" IsLogined = @IsLogined , ");
            strSql.Append(" LoginTimes = @LoginTimes , ");
            strSql.Append(" ProvinceID = @ProvinceID , ");
            strSql.Append(" CityID = @CityID , ");
            strSql.Append(" CountyID = @CountyID , ");
            strSql.Append(" Address = @Address , ");
            strSql.Append(" UserName = @UserName , ");
            strSql.Append(" Sex = @Sex , ");
            strSql.Append(" Phone = @Phone , ");
            strSql.Append(" QQ = @QQ , ");
            strSql.Append(" Wechat = @Wechat , ");
            strSql.Append(" Email = @Email, ");
            strSql.Append(" DepartmentID = @DepartmentID ,");
            strSql.Append(" SId = @SId ");
            strSql.Append(" where UserID=@UserID ");

            SqlParameter[] parameters =
            {
                new SqlParameter("@UserID",             model.UserID),
                new SqlParameter("@UserType",           model.UserType),
                new SqlParameter("@GravatarResourceID", model.GravatarResourceID),
                new SqlParameter("@LastAccessIP",       model.LastAccessIP),
                new SqlParameter("@CompanyName",        model.CompanyName),
                new SqlParameter("@CreatUserID",        model.CreatUserID),
                new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID),
                new SqlParameter("@RecordIsDelete",     model.RecordIsDelete),
                new SqlParameter("@RecordUpdateTime",   model.RecordUpdateTime),
                new SqlParameter("@RecordCreateTime",   model.RecordCreateTime),
                new SqlParameter("@CardID",             model.CardID),
                new SqlParameter("@LoginName",          model.LoginName),
                new SqlParameter("@ReginId",            model.ReginId),
                new SqlParameter("@IsLocked",           model.IsLocked),
                new SqlParameter("@IsLogined",          model.IsLogined),
                new SqlParameter("@LoginTimes",         model.LoginTimes),
                new SqlParameter("@ProvinceID",         model.ProvinceID),
                new SqlParameter("@CityID",             model.CityID),
                new SqlParameter("@CountyID",           model.CountyID),
                new SqlParameter("@Address",            model.Address),
                new SqlParameter("@UserName",           model.UserName),
                new SqlParameter("@Sex",                model.Sex),
                new SqlParameter("@Phone",              model.Phone),
                new SqlParameter("@QQ",                 model.QQ),
                new SqlParameter("@Wechat",             model.Wechat),
                new SqlParameter("@Email",              model.Email),
                new SqlParameter("@DepartmentID",       model.DepartmentID),
                new SqlParameter("@SId",                model.SId)
            };

            int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #6
0
        /// <summary>
        /// datarow转成对象实体
        /// </summary>
        public BWJS.Model.Users DataRowToModel(DataRow row)
        {
            BWJS.Model.Users model = new BWJS.Model.Users();

            if (row != null)
            {
                if (row["UserID"].ToString() != "")
                {
                    model.UserID = int.Parse(row["UserID"].ToString());
                }
                if (row["UserType"].ToString() != "")
                {
                    model.UserType = int.Parse(row["UserType"].ToString());
                }
                model.GravatarResourceID = row["GravatarResourceID"].ToString();
                model.LastAccessIP       = row["LastAccessIP"].ToString();
                model.CompanyName        = row["CompanyName"].ToString();
                if (row["CreatUserID"].ToString() != "")
                {
                    model.CreatUserID = int.Parse(row["CreatUserID"].ToString());
                }
                if (row["RecordUpdateUserID"].ToString() != "")
                {
                    model.RecordUpdateUserID = int.Parse(row["RecordUpdateUserID"].ToString());
                }
                if (row["RecordIsDelete"].ToString() != "")
                {
                    if ((row["RecordIsDelete"].ToString() == "1") || (row["RecordIsDelete"].ToString().ToLower() == "true"))
                    {
                        model.RecordIsDelete = true;
                    }
                    else
                    {
                        model.RecordIsDelete = false;
                    }
                }
                if (row["RecordUpdateTime"].ToString() != "")
                {
                    model.RecordUpdateTime = DateTime.Parse(row["RecordUpdateTime"].ToString());
                }
                if (row["RecordCreateTime"].ToString() != "")
                {
                    model.RecordCreateTime = DateTime.Parse(row["RecordCreateTime"].ToString());
                }
                model.CardID    = row["CardID"].ToString();
                model.LoginName = row["LoginName"].ToString();
                if (row["ReginId"].ToString() != "")
                {
                    model.ReginId = int.Parse(row["ReginId"].ToString());
                }
                if (row["IsLocked"].ToString() != "")
                {
                    model.IsLocked = int.Parse(row["IsLocked"].ToString());
                }
                if (row["IsLogined"].ToString() != "")
                {
                    model.IsLogined = int.Parse(row["IsLogined"].ToString());
                }
                if (row["LoginTimes"].ToString() != "")
                {
                    model.LoginTimes = int.Parse(row["LoginTimes"].ToString());
                }
                if (row["ProvinceID"].ToString() != "")
                {
                    model.ProvinceID = int.Parse(row["ProvinceID"].ToString());
                }
                if (row["CityID"].ToString() != "")
                {
                    model.CityID = int.Parse(row["CityID"].ToString());
                }
                if (row["CountyID"].ToString() != "")
                {
                    model.CountyID = int.Parse(row["CountyID"].ToString());
                }
                model.Address  = row["Address"].ToString();
                model.Password = row["Password"].ToString();
                model.UserName = row["UserName"].ToString();
                model.Sex      = row["Sex"].ToString();
                model.Phone    = row["Phone"].ToString();
                model.QQ       = row["QQ"].ToString();
                model.Wechat   = row["Wechat"].ToString();
                model.Email    = row["Email"].ToString();
                if (row["DepartmentID"].ToString() != "")
                {
                    model.DepartmentID = int.Parse(row["DepartmentID"].ToString());
                }
                if (row["SId"].ToString() != "")
                {
                    model.SId = row["SId"].ToString();
                }

                MachineDAL dalMachine   = new MachineDAL();
                Machine    modelMachine = dalMachine.GetModelByUserId(model.UserID);
                model.EquipmentNo = ((modelMachine == null) ? (string.Empty) : (modelMachine.MachineID.ToString()));

                return(model);
            }
            else
            {
                return(null);
            }
        }
예제 #7
0
파일: UsersBLL.cs 프로젝트: hofmannzhu/bwjs
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(BWJS.Model.Users model)
 {
     return(dal.Update(model));
 }
예제 #8
0
파일: UsersBLL.cs 프로젝트: hofmannzhu/bwjs
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool UpdateDepartmentID(BWJS.Model.Users model)
 {
     return(dal.UpdateDepartmentID(model));
 }
예제 #9
0
파일: UsersBLL.cs 프로젝트: hofmannzhu/bwjs
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(BWJS.Model.Users model)
 {
     return(dal.Add(model));
 }