/// <summary>
/// 获得数据列表
/// </summary>
public List<Maticsoft.Model.Tao.TradeDetails> DataTableToList(DataTable dt)
{
List<Maticsoft.Model.Tao.TradeDetails> modelList = new List<Maticsoft.Model.Tao.TradeDetails>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Maticsoft.Model.Tao.TradeDetails model;
for (int n = 0; n < rowsCount; n++)
{
model = new Maticsoft.Model.Tao.TradeDetails();
if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
if (dt.Rows[n]["UserID"] != null && dt.Rows[n]["UserID"].ToString() != "")
{
model.UserID = int.Parse(dt.Rows[n]["UserID"].ToString());
}
if (dt.Rows[n]["CreateDate"] != null && dt.Rows[n]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(dt.Rows[n]["CreateDate"].ToString());
}
if (dt.Rows[n]["TradeType"] != null && dt.Rows[n]["TradeType"].ToString() != "")
{
model.TradeType = int.Parse(dt.Rows[n]["TradeType"].ToString());
}
if (dt.Rows[n]["TradeAmount"] != null && dt.Rows[n]["TradeAmount"].ToString() != "")
{
model.TradeAmount = decimal.Parse(dt.Rows[n]["TradeAmount"].ToString());
}
if (dt.Rows[n]["Balance"] != null && dt.Rows[n]["Balance"].ToString() != "")
{
model.Balance = decimal.Parse(dt.Rows[n]["Balance"].ToString());
}
if (dt.Rows[n]["Payer"] != null && dt.Rows[n]["Payer"].ToString() != "")
{
model.Payer = int.Parse(dt.Rows[n]["Payer"].ToString());
}
if (dt.Rows[n]["Payee"] != null && dt.Rows[n]["Payee"].ToString() != "")
{
model.Payee = int.Parse(dt.Rows[n]["Payee"].ToString());
}
if (dt.Rows[n]["PaymentTypeId"] != null && dt.Rows[n]["PaymentTypeId"].ToString() != "")
{
model.PaymentTypeId = int.Parse(dt.Rows[n]["PaymentTypeId"].ToString());
}
if (dt.Rows[n]["Status"] != null && dt.Rows[n]["Status"].ToString() != "")
{
model.Status = int.Parse(dt.Rows[n]["Status"].ToString());
}
if (dt.Rows[n]["Remark"] != null && dt.Rows[n]["Remark"].ToString() != "")
{
model.Remark = dt.Rows[n]["Remark"].ToString();
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Tao.TradeDetails GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,UserID,CreateDate,TradeType,TradeAmount,Balance,Payer,Payee,PaymentTypeId,Status,Remark from Tao_TradeDetails ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)
};
parameters[0].Value = ID;
Maticsoft.Model.Tao.TradeDetails model = new Maticsoft.Model.Tao.TradeDetails();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateDate"] != null && ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if (ds.Tables[0].Rows[0]["TradeType"] != null && ds.Tables[0].Rows[0]["TradeType"].ToString() != "")
{
model.TradeType = int.Parse(ds.Tables[0].Rows[0]["TradeType"].ToString());
}
if (ds.Tables[0].Rows[0]["TradeAmount"] != null && ds.Tables[0].Rows[0]["TradeAmount"].ToString() != "")
{
model.TradeAmount = decimal.Parse(ds.Tables[0].Rows[0]["TradeAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["Balance"] != null && ds.Tables[0].Rows[0]["Balance"].ToString() != "")
{
model.Balance = decimal.Parse(ds.Tables[0].Rows[0]["Balance"].ToString());
}
if (ds.Tables[0].Rows[0]["Payer"] != null && ds.Tables[0].Rows[0]["Payer"].ToString() != "")
{
model.Payer = int.Parse(ds.Tables[0].Rows[0]["Payer"].ToString());
}
if (ds.Tables[0].Rows[0]["Payee"] != null && ds.Tables[0].Rows[0]["Payee"].ToString() != "")
{
model.Payee = int.Parse(ds.Tables[0].Rows[0]["Payee"].ToString());
}
if (ds.Tables[0].Rows[0]["PaymentTypeId"] != null && ds.Tables[0].Rows[0]["PaymentTypeId"].ToString() != "")
{
model.PaymentTypeId = int.Parse(ds.Tables[0].Rows[0]["PaymentTypeId"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"] != null && ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "")
{
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
}
return model;
}
else
{
return null;
}
}
