/// <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));
}
