/// <summary>
/// 更新一条数据
/// </summary>
public void Update(tdps.Model.NSRXXDS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update NSRXXDS set ");
strSql.Append("SSHY=@SSHY,");
strSql.Append("SSYH=@SSYH,");
strSql.Append("QYDJZCL=@QYDJZCL,");
strSql.Append("NSLX=@NSLX,");
strSql.Append("SFTYHSJG=@SFTYHSJG,");
strSql.Append("ZGSWJG=@ZGSWJG,");
strSql.Append("ZGSWJG_MC=@ZGSWJG_MC,");
strSql.Append("NSR_SWJG_DM=@NSR_SWJG_DM,");
strSql.Append("JKBZ=@JKBZ,");
strSql.Append("XY=@XY,");
strSql.Append("LSGX=@LSGX,");
strSql.Append("NSRBM=@NSRBM,");
strSql.Append("NSRZT=@NSRZT,");
strSql.Append("ZGY=@ZGY");
strSql.Append(" where NSRSBH=@NSRSBH ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@NSRSBH", DbType.String, 20),
new SQLiteParameter("@SSHY", DbType.String, 60),
new SQLiteParameter("@SSYH", DbType.String, 50),
new SQLiteParameter("@QYDJZCL", DbType.String, 60),
new SQLiteParameter("@NSLX", DbType.String, 50),
new SQLiteParameter("@SFTYHSJG", DbType.Int32, 4),
new SQLiteParameter("@ZGSWJG", DbType.String, 20),
new SQLiteParameter("@ZGSWJG_MC", DbType.String, 100),
new SQLiteParameter("@NSR_SWJG_DM", DbType.String, 20),
new SQLiteParameter("@JKBZ", DbType.Int32, 4),
new SQLiteParameter("@XY", DbType.String, 50),
new SQLiteParameter("@LSGX", DbType.String, 100),
new SQLiteParameter("@NSRBM", DbType.String, 20),
new SQLiteParameter("@NSRZT", DbType.String, 2),
new SQLiteParameter("@ZGY", DbType.String, 30)
};
parameters[0].Value = model.NSRSBH;
parameters[1].Value = model.SSHY;
parameters[2].Value = model.SSYH;
parameters[3].Value = model.QYDJZCL;
parameters[4].Value = model.NSLX;
parameters[5].Value = model.SFTYHSJG;
parameters[6].Value = model.ZGSWJG;
parameters[7].Value = model.ZGSWJG_MC;
parameters[8].Value = model.NSR_SWJG_DM;
parameters[9].Value = model.JKBZ;
parameters[10].Value = model.XY;
parameters[11].Value = model.LSGX;
parameters[12].Value = model.NSRBM;
parameters[13].Value = model.NSRZT;
parameters[14].Value = model.ZGY;
SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(tdps.Model.NSRXXDS model, object trans)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into NSRXXDS(");
strSql.Append("NSRSBH,SSHY,SSYH,QYDJZCL,NSLX,SFTYHSJG,ZGSWJG,ZGSWJG_MC,NSR_SWJG_DM,JKBZ,XY,LSGX,NSRBM,NSRZT,ZGY,SSHY_MC,QYDJZCL_MC,LSGX_MC)");
strSql.Append(" values (");
strSql.Append("@NSRSBH,@SSHY,@SSYH,@QYDJZCL,@NSLX,@SFTYHSJG,@ZGSWJG,@ZGSWJG_MC,@NSR_SWJG_DM,@JKBZ,@XY,@LSGX,@NSRBM,@NSRZT,@ZGY,@SSHY_MC,@QYDJZCL_MC,@LSGX_MC)");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@NSRSBH", DbType.String, 20),
new SQLiteParameter("@SSHY", DbType.String, 60),
new SQLiteParameter("@SSYH", DbType.String, 50),
new SQLiteParameter("@QYDJZCL", DbType.String, 60),
new SQLiteParameter("@NSLX", DbType.String, 50),
new SQLiteParameter("@SFTYHSJG", DbType.Int32, 4),
new SQLiteParameter("@ZGSWJG", DbType.String, 20),
new SQLiteParameter("@ZGSWJG_MC", DbType.String, 100),
new SQLiteParameter("@NSR_SWJG_DM", DbType.String, 20),
new SQLiteParameter("@JKBZ", DbType.Int32, 4),
new SQLiteParameter("@XY", DbType.String, 50),
new SQLiteParameter("@LSGX", DbType.String, 100),
new SQLiteParameter("@NSRBM", DbType.String, 20),
new SQLiteParameter("@NSRZT", DbType.String, 2),
new SQLiteParameter("@ZGY", DbType.String, 30),
new SQLiteParameter("@SSHY_MC", DbType.String, 50),
new SQLiteParameter("@QYDJZCL_MC", DbType.String, 50),
new SQLiteParameter("@LSGX_MC", DbType.String, 50)
};
parameters[0].Value = model.NSRSBH;
parameters[1].Value = model.SSHY;
parameters[2].Value = model.SSYH;
parameters[3].Value = model.QYDJZCL;
parameters[4].Value = model.NSLX;
parameters[5].Value = model.SFTYHSJG;
parameters[6].Value = model.ZGSWJG;
parameters[7].Value = model.ZGSWJG_MC;
parameters[8].Value = model.NSR_SWJG_DM;
parameters[9].Value = model.JKBZ;
parameters[10].Value = model.XY;
parameters[11].Value = model.LSGX;
parameters[12].Value = model.NSRBM;
parameters[13].Value = model.NSRZT;
parameters[14].Value = model.ZGY;
parameters[15].Value = model.SSHY_MC;
parameters[16].Value = model.QYDJZCL_MC;
parameters[17].Value = model.LSGX_MC;
SQLiteHelper.ExecuteNonQueryByTransaction(strSql.ToString(), (SQLiteTransaction)trans, parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tdps.Model.NSRXXDS GetModel(string NSRSBH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select NSRSBH,SSHY,SSYH,QYDJZCL,NSLX,SFTYHSJG,ZGSWJG,ZGSWJG_MC,NSR_SWJG_DM,JKBZ,XY,LSGX,NSRBM,NSRZT,ZGY,SSHY_MC,QYDJZCL_MC,LSGX_MC from NSRXXDS ");
strSql.Append(" where NSRSBH=@NSRSBH ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@NSRSBH", DbType.String, 50)
};
parameters[0].Value = NSRSBH;
tdps.Model.NSRXXDS model = new tdps.Model.NSRXXDS();
DataSet ds = SQLiteHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.NSRSBH = ds.Tables[0].Rows[0]["NSRSBH"].ToString();
model.SSHY = ds.Tables[0].Rows[0]["SSHY"].ToString();
model.SSHY_MC = ds.Tables[0].Rows[0]["SSHY_MC"].ToString();
model.SSYH = ds.Tables[0].Rows[0]["SSYH"].ToString();
model.QYDJZCL = ds.Tables[0].Rows[0]["QYDJZCL"].ToString();
model.QYDJZCL_MC = ds.Tables[0].Rows[0]["QYDJZCL_MC"].ToString();
model.NSLX = ds.Tables[0].Rows[0]["NSLX"].ToString();
if (ds.Tables[0].Rows[0]["SFTYHSJG"].ToString() != "")
{
model.SFTYHSJG = int.Parse(ds.Tables[0].Rows[0]["SFTYHSJG"].ToString());
}
model.ZGSWJG = ds.Tables[0].Rows[0]["ZGSWJG"].ToString();
model.ZGSWJG_MC = ds.Tables[0].Rows[0]["ZGSWJG_MC"].ToString();
model.NSR_SWJG_DM = ds.Tables[0].Rows[0]["NSR_SWJG_DM"].ToString();
if (ds.Tables[0].Rows[0]["JKBZ"].ToString() != "")
{
model.JKBZ = int.Parse(ds.Tables[0].Rows[0]["JKBZ"].ToString());
}
model.XY = ds.Tables[0].Rows[0]["XY"].ToString();
model.LSGX = ds.Tables[0].Rows[0]["LSGX"].ToString();
model.LSGX_MC = ds.Tables[0].Rows[0]["LSGX_MC"].ToString();
model.NSRBM = ds.Tables[0].Rows[0]["NSRBM"].ToString();
model.NSRZT = ds.Tables[0].Rows[0]["NSRZT"].ToString();
model.ZGY = ds.Tables[0].Rows[0]["ZGY"].ToString();
return(model);
}
else
{
return(null);
}
}
