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