public List<Maticsoft.Model.Shop.Gift.ExchangeDetail> DataTableToList(DataTable dt)
{
List<Maticsoft.Model.Shop.Gift.ExchangeDetail> list = new List<Maticsoft.Model.Shop.Gift.ExchangeDetail>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Maticsoft.Model.Shop.Gift.ExchangeDetail item = new Maticsoft.Model.Shop.Gift.ExchangeDetail();
if ((dt.Rows[i]["ExchangeDetailID"] != null) && (dt.Rows[i]["ExchangeDetailID"].ToString() != ""))
{
item.ExchangeDetailID = int.Parse(dt.Rows[i]["ExchangeDetailID"].ToString());
}
if ((dt.Rows[i]["GiftID"] != null) && (dt.Rows[i]["GiftID"].ToString() != ""))
{
item.GiftID = int.Parse(dt.Rows[i]["GiftID"].ToString());
}
if ((dt.Rows[i]["UserID"] != null) && (dt.Rows[i]["UserID"].ToString() != ""))
{
item.UserID = int.Parse(dt.Rows[i]["UserID"].ToString());
}
if ((dt.Rows[i]["OrderID"] != null) && (dt.Rows[i]["OrderID"].ToString() != ""))
{
item.OrderID = new int?(int.Parse(dt.Rows[i]["OrderID"].ToString()));
}
if ((dt.Rows[i]["GiftName"] != null) && (dt.Rows[i]["GiftName"].ToString() != ""))
{
item.GiftName = dt.Rows[i]["GiftName"].ToString();
}
if ((dt.Rows[i]["CostScore"] != null) && (dt.Rows[i]["CostScore"].ToString() != ""))
{
item.CostScore = int.Parse(dt.Rows[i]["CostScore"].ToString());
}
if ((dt.Rows[i]["Status"] != null) && (dt.Rows[i]["Status"].ToString() != ""))
{
item.Status = int.Parse(dt.Rows[i]["Status"].ToString());
}
if ((dt.Rows[i]["Description"] != null) && (dt.Rows[i]["Description"].ToString() != ""))
{
item.Description = dt.Rows[i]["Description"].ToString();
}
if ((dt.Rows[i]["CreatedDate"] != null) && (dt.Rows[i]["CreatedDate"].ToString() != ""))
{
item.CreatedDate = DateTime.Parse(dt.Rows[i]["CreatedDate"].ToString());
}
list.Add(item);
}
}
return list;
}
public Maticsoft.Model.Shop.Gift.ExchangeDetail GetModel(int ExchangeDetailID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 ExchangeDetailID,GiftID,UserID,OrderID,GiftName,CostScore,Status,Description,CreatedDate from Shop_ExchangeDetail ");
builder.Append(" where ExchangeDetailID=@ExchangeDetailID");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ExchangeDetailID", SqlDbType.Int, 4) };
cmdParms[0].Value = ExchangeDetailID;
Maticsoft.Model.Shop.Gift.ExchangeDetail detail = new Maticsoft.Model.Shop.Gift.ExchangeDetail();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if ((set.Tables[0].Rows[0]["ExchangeDetailID"] != null) && (set.Tables[0].Rows[0]["ExchangeDetailID"].ToString() != ""))
{
detail.ExchangeDetailID = int.Parse(set.Tables[0].Rows[0]["ExchangeDetailID"].ToString());
}
if ((set.Tables[0].Rows[0]["GiftID"] != null) && (set.Tables[0].Rows[0]["GiftID"].ToString() != ""))
{
detail.GiftID = int.Parse(set.Tables[0].Rows[0]["GiftID"].ToString());
}
if ((set.Tables[0].Rows[0]["UserID"] != null) && (set.Tables[0].Rows[0]["UserID"].ToString() != ""))
{
detail.UserID = int.Parse(set.Tables[0].Rows[0]["UserID"].ToString());
}
if ((set.Tables[0].Rows[0]["OrderID"] != null) && (set.Tables[0].Rows[0]["OrderID"].ToString() != ""))
{
detail.OrderID = new int?(int.Parse(set.Tables[0].Rows[0]["OrderID"].ToString()));
}
if ((set.Tables[0].Rows[0]["GiftName"] != null) && (set.Tables[0].Rows[0]["GiftName"].ToString() != ""))
{
detail.GiftName = set.Tables[0].Rows[0]["GiftName"].ToString();
}
if ((set.Tables[0].Rows[0]["CostScore"] != null) && (set.Tables[0].Rows[0]["CostScore"].ToString() != ""))
{
detail.CostScore = int.Parse(set.Tables[0].Rows[0]["CostScore"].ToString());
}
if ((set.Tables[0].Rows[0]["Status"] != null) && (set.Tables[0].Rows[0]["Status"].ToString() != ""))
{
detail.Status = int.Parse(set.Tables[0].Rows[0]["Status"].ToString());
}
if ((set.Tables[0].Rows[0]["Description"] != null) && (set.Tables[0].Rows[0]["Description"].ToString() != ""))
{
detail.Description = set.Tables[0].Rows[0]["Description"].ToString();
}
if ((set.Tables[0].Rows[0]["CreatedDate"] != null) && (set.Tables[0].Rows[0]["CreatedDate"].ToString() != ""))
{
detail.CreatedDate = DateTime.Parse(set.Tables[0].Rows[0]["CreatedDate"].ToString());
}
return detail;
}
