/// <summary>
/// 获得数据列表
/// </summary>
public List <tdps.Model.NSRZJG> DataTableToList(DataTable dt)
{
List <tdps.Model.NSRZJG> modelList = new List <tdps.Model.NSRZJG>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
tdps.Model.NSRZJG model;
for (int n = 0; n < rowsCount; n++)
{
model = new tdps.Model.NSRZJG();
model.nsrsbh = dt.Rows[n]["nsrsbh"].ToString();
model.zjgNsrsbh = dt.Rows[n]["zjgNsrsbh"].ToString();
model.zjgMc = dt.Rows[n]["zjgMc"].ToString();
model.kjzg = dt.Rows[n]["kjzg"].ToString();
model.LXDH = dt.Rows[n]["LXDH"].ToString();
model.ND = dt.Rows[n]["ND"].ToString();
if (dt.Rows[n]["SRZE"].ToString() != "")
{
model.SRZE = decimal.Parse(dt.Rows[n]["SRZE"].ToString());
}
if (dt.Rows[n]["GZZE"].ToString() != "")
{
model.GZZE = decimal.Parse(dt.Rows[n]["GZZE"].ToString());
}
if (dt.Rows[n]["ZCZE"].ToString() != "")
{
model.ZCZE = decimal.Parse(dt.Rows[n]["ZCZE"].ToString());
}
if (dt.Rows[n]["HJ"].ToString() != "")
{
model.HJ = decimal.Parse(dt.Rows[n]["HJ"].ToString());
}
if (dt.Rows[n]["QDZT"].ToString() != "")
{
model.QDZT = dt.Rows[n]["QDZT"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(tdps.Model.NSRZJG model, object trans)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update NSRZJG set ");
strSql.Append("zjgNsrsbh=@zjgNsrsbh,");
strSql.Append("zjgMc=@zjgMc,");
strSql.Append("kjzg=@kjzg,");
strSql.Append("LXDH=@LXDH,");
strSql.Append("ND=@ND,");
strSql.Append("SRZE=@SRZE,");
strSql.Append("GZZE=@GZZE,");
strSql.Append("ZCZE=@ZCZE,");
strSql.Append("HJ=@HJ");
strSql.Append(" where zjgnsrsbh=@nsrsbh and ND=@ND");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@nsrsbh", DbType.String, 20),
new SQLiteParameter("@zjgNsrsbh", DbType.String, 20),
new SQLiteParameter("@zjgMc", DbType.String, 80),
new SQLiteParameter("@kjzg", DbType.String, 20),
new SQLiteParameter("@LXDH", DbType.String, 20),
new SQLiteParameter("@ND", DbType.String, 4),
new SQLiteParameter("@SRZE", DbType.Decimal, 9),
new SQLiteParameter("@GZZE", DbType.Decimal, 9),
new SQLiteParameter("@ZCZE", DbType.Decimal, 9),
new SQLiteParameter("@HJ", DbType.Decimal, 9)
};
parameters[0].Value = model.nsrsbh;
parameters[1].Value = model.zjgNsrsbh;
parameters[2].Value = model.zjgMc;
parameters[3].Value = model.kjzg;
parameters[4].Value = model.LXDH;
parameters[5].Value = model.ND;
parameters[6].Value = model.SRZE;
parameters[7].Value = model.GZZE;
parameters[8].Value = model.ZCZE;
parameters[9].Value = model.HJ;
return(SQLiteHelper.ExecuteNonQueryByTransaction(strSql.ToString(), (SQLiteTransaction)trans, parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(tdps.Model.NSRZJG model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(tdps.Model.NSRZJG model)
{
dal.Add(model);
}