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