/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList(DataRow dr, MODEL.T_Sizi tsize)
{
tsize.Guid = (Guid)SqlHelper.FromDbValue(dr["Guid"]); //GUiD
tsize.CustomStyleCode = (string)SqlHelper.FromDbValue(dr["CustomStyleCode"]); //订单号
tsize.Size = (string)SqlHelper.FromDbValue(dr["Size"]);
tsize.Ccount = (string)SqlHelper.FromDbValue(dr["Ccount"]);
}
/// 获取订单的尺碼明細
/// </summary>
/// <param name>date</param>
/// <returns></returns>
public List <MODEL.T_Sizi> GetTSize(string comstomstylecode)
{
string sql = " select Guid,CustomStyleCode,Size,Ccount from T_Sizi where CustomStyleCode=@CustomStyleCode ";
SqlParameter[] ps =
{
new SqlParameter("CustomStyleCode", comstomstylecode)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
List <MODEL.T_Sizi> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.T_Sizi>();
foreach (DataRow row in dt.Rows)
{
MODEL.T_Sizi c = new MODEL.T_Sizi();
LoadDataToList(row, c);
lists.Add(c);
}
}
return(lists);
}
