public MD_CarColorsList GetColorsListI()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CL_Code,CL_Color_EN,CL_Color_CN from CT_Color_List");
DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSql.ToString());
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count <= 0)
{
return(null);
}
Model.MyCar.MD_CarColorsList CarColorsList = new MD_CarColorsList();
CarColorsList.Car_Color_I = new List <CRMTree.Model.CT_Color_List>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CarColorsList.Car_Color_I.Add(new CRMTree.Model.CT_Color_List()
{
CL_Code = int.Parse(ds.Tables[0].Rows[i]["CL_Code"].ToString()),
CL_Color_EN = ds.Tables[0].Rows[i]["CL_Color_EN"].ToString(),
CL_Color_CN = ds.Tables[0].Rows[i]["CL_Color_CN"].ToString()
});
}
return(CarColorsList);
}
/// <summary>
/// 汽车颜色
/// </summary>
/// <returns></returns>
public MD_CarColorsList GetColorsList()
{
string sql = "select * from CT_Color_List";
DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, sql);
MD_CarColorsList _o = new MD_CarColorsList();
_o.Car_Color = DataHelper.ConvertToList <CT_Color_List>(ds);
return(_o);
}
