/// <summary> /// 更新一条数据 /// </summary> public bool Update_CT_All_Users(CT_All_Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CT_All_Users set "); strSql.Append("AU_Username=@AU_Username,"); strSql.Append("AU_Password=@AU_Password"); strSql.Append(" where AU_Code=@AU_Code"); SqlParameter[] parameters = { new SqlParameter("@AU_Username", SqlDbType.NVarChar, 40), new SqlParameter("@AU_Password", SqlDbType.NVarChar, 32), new SqlParameter("@AU_Code", SqlDbType.BigInt, 8) }; parameters[0].Value = model.AU_Username; parameters[1].Value = model.AU_Password; parameters[2].Value = model.AU_Code; int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 根据登陆获取登陆信息 /// </summary> /// <param name="AU_Username"></param> /// <param name="AU_Password"></param> /// <returns></returns> public CT_All_Users GetUser(string AU_Username, string AU_Password) { string strSql = string.Format("select UG.UG_UType,AU.* from CT_All_Users AU with(nolock) inner join CT_User_Groups UG with(nolock) on AU_UG_Code=UG_Code where AU_Active_tag=1 and AU_Username='******' and AU_Password='******';", AU_Username, AU_Password); CT_All_Users User = DataHelper.ConvertToObject <CT_All_Users>(strSql); return(User); }
public CT_All_Users GetTXCam_Number(int AU_Code, int AP_Code) { string sql = string.Format(@"select top 1 PL_Number from ( select pl.* from CT_Phone_List pl inner join CT_Appt_Service a on a.AP_PL_ML_Code=pl.PL_Code and a.AP_Cont_Type=3 where ISNULL(PL_Active,1)=1 and PL_Type=3 and PL_Code={0} Union select * from CT_Phone_List where ISNULL(PL_Active,1)=1 and PL_Type=3 and PL_AU_AD_Code={1} )a order by PL_Pref", AP_Code, AU_Code); CT_All_Users _o = DataHelper.ConvertToObject <CT_All_Users>(sql); return(_o); }
private void Key_01_Save(dynamic data) { CT_All_Users _user = new CT_All_Users(); _user.OpenId = _http.Session["OpenId"].ToString(); _user.AU_Name = data.UserName; _user.AU_B_date = Convert.ToDateTime(data.birthday); _user.AU_Gender = Convert.ToBoolean(data.sex); _user.Phone = data.Moblid; int i = _user_Entity.Modify_User_Info(_user); _object = i; }
/// <summary> /// 修改用户的信息 /// </summary> /// <param name="_u"></param> /// <returns></returns> public int Modify_User_Info(CT_All_Users _u) { #region 参数 SqlParameter[] parameters = { new SqlParameter("@CS_OpenId", SqlDbType.VarChar, 200), new SqlParameter("@AU_Name", SqlDbType.VarChar, 30), new SqlParameter("@AU_B_DATE", SqlDbType.DateTime), new SqlParameter("@Phone", SqlDbType.VarChar, 15), new SqlParameter("@AU_Gender", SqlDbType.Bit), }; parameters[0].Value = _u.OpenId; parameters[1].Value = _u.AU_Name; parameters[2].Value = _u.AU_B_date; parameters[3].Value = _u.Phone; parameters[4].Value = _u.AU_Gender; #endregion return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "02_Modify_User_W", parameters)); }
public bool Update_CT_All_Users(CT_All_Users model) { return(new DL_UserEntity().Update_CT_All_Users(model)); }
public int Modify_User_Info(CT_All_Users _u) { return(DL_User.Modify_User_Info(_u)); }