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