/// <summary> /// 根据客户类型ID查询类型名称 /// </summary> /// <param name="custoType"></param> /// <returns></returns> public CustoType SelectCustoTypeByTypeId(CustoType custoType) { CustoType custoTypes = new CustoType(); custoType = base.Change <CustoType>().GetSingle(a => a.UserType == custoType.UserType && a.delete_mk != 1); return(custoTypes); }
/// <summary> /// 更新客户类型 /// </summary> /// <param name="custoType"></param> /// <returns></returns> public bool UpdateCustoType(CustoType custoType) { return(base.Change <CustoType>().Update(a => new CustoType() { TypeName = custoType.TypeName, datachg_usr = AdminInfo.Account, datachg_date = DateTime.Now }, a => a.UserType == custoType.UserType)); }
public static List <CustoType> SelectCustoTypesAll() { List <CustoType> types = new List <CustoType>(); string sql = "select * from usertype"; MySqlDataReader dr = DBHelper.ExecuteReader(sql); while (dr.Read()) { CustoType type = new CustoType(); type.UserType = (int)dr["UserType"]; type.TypeName = dr["TypeName"].ToString(); types.Add(type); } dr.Close(); DBHelper.Closecon(); return(types); }
/// <summary> /// 添加客户类型 /// </summary> /// <param name="custoType"></param> /// <returns></returns> public bool InsertCustoType(CustoType custoType) { return(base.Change <CustoType>().Insert(custoType)); }