/// <summary> /// 用户表修改 /// </summary> /// <param name="update"></param> /// <returns></returns> public int CP_UsersUpdate(CP_Users update) { return(dal.CP_UsersUpdate(update)); }
/// <summary> /// 用户表修改 /// </summary> /// <param name="update"></param> /// <returns></returns> public int CP_UsersUpdate(CP_Users update) { string sql = "update CP_Users set U_Name='{0}',U_PassWord='******',U_Phone='{2}',U_TName='{3}',U_IDCard='{4}',U_CreditScore='{5}',U_Icon='{6}',V_Id='{7}',U_Time='{8}'U_day='{9}',U_Month='{10}' where U_id='{11}'"; return(DBHelper.ExecuteNonQuery(sql)); }
/// <summary> /// 用户表添加 /// </summary> /// <param name="add"></param> /// <returns></returns> public int CP_UsersAdd(CP_Users add) { return(dal.CP_UsersAdd(add)); }
/// <summary> /// 用户表添加 /// </summary> /// <param name="add"></param> /// <returns></returns> public int CP_UsersAdd(CP_Users add) { string sql = string.Format("insert into CP_Users vslues('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", add.U_Name, add.U_PassWord, add.U_Phone, add.U_TName, add.U_IDCard, add.U_CreditScore, add.U_Icon, add.V_Id, add.U_Id, add.U_Time, add.U_day, add.U_Month); return(DBHelper.ExecuteNonQuery(sql)); }