/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(tdps.Model.KKCL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(FID) from KKCL");
strSql.Append(" where FileName=@FileName ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@FileName", DbType.String, 200)
};
parameters[0].Value = model.FileName;
return(SQLiteHelper.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(tdps.Model.KKCL model, object trans)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into KKCL(");
strSql.Append("SBXXID,HZLX,NSRSBH,NSRMC,SWJGMC,YHDM,YHZH,KKFSSJ,KKCLSJ,JYLSH,DZYZData,SBWJ,SBZL,TSXX,ZT,ZJE,KKJE,WJJE,SBZLMC,SBCS,SSQQ,SSQZ,KKSJ,SBFKYZM,FKDM,FKXX,SZ,FileName,MW)");
strSql.Append(" values (");
strSql.Append("@SBXXID,@HZLX,@NSRSBH,@NSRMC,@SWJGMC,@YHDM,@YHZH,@KKFSSJ,@KKCLSJ,@JYLSH,@DZYZData,@SBWJ,@SBZL,@TSXX,@ZT,@ZJE,@KKJE,@WJJE,@SBZLMC,@SBCS,@SSQQ,@SSQZ,@KKSJ,@SBFKYZM,@FKDM,@FKXX,@SZ,@FileName,@MW)");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@SBXXID", DbType.Int32, 4),
new SQLiteParameter("@HZLX", DbType.String, 4),
new SQLiteParameter("@NSRSBH", DbType.String, 20),
new SQLiteParameter("@NSRMC", DbType.String, 80),
new SQLiteParameter("@SWJGMC", DbType.String, 80),
new SQLiteParameter("@YHDM", DbType.String, 12),
new SQLiteParameter("@YHZH", DbType.String, 50),
new SQLiteParameter("@KKFSSJ", DbType.String, 20),
new SQLiteParameter("@KKCLSJ", DbType.String, 20),
new SQLiteParameter("@JYLSH", DbType.String, 30),
new SQLiteParameter("@DZYZData", DbType.String),
new SQLiteParameter("@SBWJ", DbType.String, 100),
new SQLiteParameter("@SBZL", DbType.String, 20),
new SQLiteParameter("@TSXX", DbType.String),
new SQLiteParameter("@ZT", DbType.String, 20),
new SQLiteParameter("@ZJE", DbType.Decimal, 9),
new SQLiteParameter("@KKJE", DbType.Decimal, 9),
new SQLiteParameter("@WJJE", DbType.Decimal, 9),
new SQLiteParameter("@SBZLMC", DbType.String, 80),
new SQLiteParameter("@SBCS", DbType.Int32, 4),
new SQLiteParameter("@SSQQ", DbType.String, 20),
new SQLiteParameter("@SSQZ", DbType.String, 20),
new SQLiteParameter("@KKSJ", DbType.String, 20),
new SQLiteParameter("@SBFKYZM", DbType.String, 20),
new SQLiteParameter("@FKDM", DbType.String, 20),
new SQLiteParameter("@FKXX", DbType.String),
new SQLiteParameter("@SZ", DbType.String, 20),
new SQLiteParameter("@FileName", DbType.String, 200),
new SQLiteParameter("@MW", DbType.String)
};
parameters[0].Value = model.SBXXID;
parameters[1].Value = model.HZLX;
parameters[2].Value = model.NSRSBH;
parameters[3].Value = model.NSRMC;
parameters[4].Value = model.SWJGMC;
parameters[5].Value = model.YHDM;
parameters[6].Value = model.YHZH;
parameters[7].Value = model.KKFSSJ;
parameters[8].Value = model.KKCLSJ;
parameters[9].Value = model.JYLSH;
parameters[10].Value = model.DZYZData;
parameters[11].Value = model.SBWJ;
parameters[12].Value = model.SBZL;
parameters[13].Value = model.TSXX;
parameters[14].Value = model.ZT;
parameters[15].Value = model.ZJE;
parameters[16].Value = model.KKJE;
parameters[17].Value = model.WJJE;
parameters[18].Value = model.SBZLMC;
parameters[19].Value = model.SBCS;
parameters[20].Value = model.SSQQ;
parameters[21].Value = model.SSQZ;
parameters[22].Value = model.KKSJ;
parameters[23].Value = model.SBFKYZM;
parameters[24].Value = model.FKDM;
parameters[25].Value = model.FKXX;
parameters[26].Value = model.SZ;
parameters[27].Value = model.FileName;
parameters[28].Value = model.MW;
SQLiteHelper.ExecuteNonQueryByTransaction(strSql.ToString(), (SQLiteTransaction)trans, parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tdps.Model.KKCL GetModel(int FID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select FID,SBXXID,HZLX,NSRSBH,NSRMC,SWJGMC,YHDM,YHZH,KKFSSJ,KKCLSJ,JYLSH,DZYZData,SBWJ,SBZL,TSXX,ZT,ZJE,KKJE,WJJE,SBZLMC,SBCS,SSQQ,SSQZ,KKSJ,SBFKYZM,FKDM,FKXX,SZ,FileName,MW from KKCL ");
strSql.Append(" where FID=@FID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@FID", DbType.Int32, 4)
};
parameters[0].Value = FID;
tdps.Model.KKCL model = new tdps.Model.KKCL();
DataSet ds = SQLiteHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["FID"].ToString() != "")
{
model.FID = int.Parse(ds.Tables[0].Rows[0]["FID"].ToString());
}
if (ds.Tables[0].Rows[0]["SBXXID"].ToString() != "")
{
model.SBXXID = int.Parse(ds.Tables[0].Rows[0]["SBXXID"].ToString());
}
model.HZLX = ds.Tables[0].Rows[0]["HZLX"].ToString();
model.NSRSBH = ds.Tables[0].Rows[0]["NSRSBH"].ToString();
model.NSRMC = ds.Tables[0].Rows[0]["NSRMC"].ToString();
model.SWJGMC = ds.Tables[0].Rows[0]["SWJGMC"].ToString();
model.YHDM = ds.Tables[0].Rows[0]["YHDM"].ToString();
model.YHZH = ds.Tables[0].Rows[0]["YHZH"].ToString();
model.KKFSSJ = ds.Tables[0].Rows[0]["KKFSSJ"].ToString();
model.KKCLSJ = ds.Tables[0].Rows[0]["KKCLSJ"].ToString();
model.JYLSH = ds.Tables[0].Rows[0]["JYLSH"].ToString();
model.DZYZData = ds.Tables[0].Rows[0]["DZYZData"].ToString();
model.SBWJ = ds.Tables[0].Rows[0]["SBWJ"].ToString();
model.SBZL = ds.Tables[0].Rows[0]["SBZL"].ToString();
model.TSXX = ds.Tables[0].Rows[0]["TSXX"].ToString();
model.ZT = ds.Tables[0].Rows[0]["ZT"].ToString();
if (ds.Tables[0].Rows[0]["ZJE"].ToString() != "")
{
model.ZJE = decimal.Parse(ds.Tables[0].Rows[0]["ZJE"].ToString());
}
if (ds.Tables[0].Rows[0]["KKJE"].ToString() != "")
{
model.KKJE = decimal.Parse(ds.Tables[0].Rows[0]["KKJE"].ToString());
}
if (ds.Tables[0].Rows[0]["WJJE"].ToString() != "")
{
model.WJJE = decimal.Parse(ds.Tables[0].Rows[0]["WJJE"].ToString());
}
model.SBZLMC = ds.Tables[0].Rows[0]["SBZLMC"].ToString();
if (ds.Tables[0].Rows[0]["SBCS"].ToString() != "")
{
model.SBCS = int.Parse(ds.Tables[0].Rows[0]["SBCS"].ToString());
}
model.SSQQ = ds.Tables[0].Rows[0]["SSQQ"].ToString();
model.SSQZ = ds.Tables[0].Rows[0]["SSQZ"].ToString();
model.KKSJ = ds.Tables[0].Rows[0]["KKSJ"].ToString();
model.SBFKYZM = ds.Tables[0].Rows[0]["SBFKYZM"].ToString();
model.FKDM = ds.Tables[0].Rows[0]["FKDM"].ToString();
model.FKXX = ds.Tables[0].Rows[0]["FKXX"].ToString();
model.SZ = ds.Tables[0].Rows[0]["SZ"].ToString();
model.FileName = ds.Tables[0].Rows[0]["FileName"].ToString();
model.MW = ds.Tables[0].Rows[0]["MW"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(tdps.Model.KKCL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update KKCL set ");
strSql.Append("SBXXID=@SBXXID,");
strSql.Append("HZLX=@HZLX,");
strSql.Append("NSRSBH=@NSRSBH,");
strSql.Append("NSRMC=@NSRMC,");
strSql.Append("SWJGMC=@SWJGMC,");
strSql.Append("YHDM=@YHDM,");
strSql.Append("YHZH=@YHZH,");
strSql.Append("KKFSSJ=@KKFSSJ,");
strSql.Append("KKCLSJ=@KKCLSJ,");
strSql.Append("JYLSH=@JYLSH,");
strSql.Append("DZYZData=@DZYZData,");
strSql.Append("SBWJ=@SBWJ,");
strSql.Append("SBZL=@SBZL,");
strSql.Append("TSXX=@TSXX,");
strSql.Append("ZT=@ZT,");
strSql.Append("ZJE=@ZJE,");
strSql.Append("KKJE=@KKJE,");
strSql.Append("WJJE=@WJJE,");
strSql.Append("SBZLMC=@SBZLMC,");
strSql.Append("SBCS=@SBCS,");
strSql.Append("SSQQ=@SSQQ,");
strSql.Append("SSQZ=@SSQZ,");
strSql.Append("KKSJ=@KKSJ,");
strSql.Append("SBFKYZM=@SBFKYZM,");
strSql.Append("FKDM=@FKDM,");
strSql.Append("FKXX=@FKXX,");
strSql.Append("SZ=@SZ,");
strSql.Append("FileName=@FileName,");
strSql.Append("MW=@MW");
strSql.Append(" where FID=@FID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@FID", DbType.Int32, 4),
new SQLiteParameter("@SBXXID", DbType.Int32, 4),
new SQLiteParameter("@HZLX", DbType.String, 4),
new SQLiteParameter("@NSRSBH", DbType.String, 20),
new SQLiteParameter("@NSRMC", DbType.String, 80),
new SQLiteParameter("@SWJGMC", DbType.String, 80),
new SQLiteParameter("@YHDM", DbType.String, 12),
new SQLiteParameter("@YHZH", DbType.String, 50),
new SQLiteParameter("@KKFSSJ", DbType.String, 20),
new SQLiteParameter("@KKCLSJ", DbType.String, 20),
new SQLiteParameter("@JYLSH", DbType.String, 30),
new SQLiteParameter("@DZYZData", DbType.String),
new SQLiteParameter("@SBWJ", DbType.String, 100),
new SQLiteParameter("@SBZL", DbType.String, 20),
new SQLiteParameter("@TSXX", DbType.String),
new SQLiteParameter("@ZT", DbType.String, 20),
new SQLiteParameter("@ZJE", DbType.Decimal, 9),
new SQLiteParameter("@KKJE", DbType.Decimal, 9),
new SQLiteParameter("@WJJE", DbType.Decimal, 9),
new SQLiteParameter("@SBZLMC", DbType.String, 80),
new SQLiteParameter("@SBCS", DbType.Int32, 4),
new SQLiteParameter("@SSQQ", DbType.String, 20),
new SQLiteParameter("@SSQZ", DbType.String, 20),
new SQLiteParameter("@KKSJ", DbType.String, 20),
new SQLiteParameter("@SBFKYZM", DbType.String, 20),
new SQLiteParameter("@FKDM", DbType.String, 20),
new SQLiteParameter("@FKXX", DbType.String),
new SQLiteParameter("@SZ", DbType.String, 20),
new SQLiteParameter("@FileName", DbType.String, 200),
new SQLiteParameter("@MW", DbType.String)
};
parameters[0].Value = model.FID;
parameters[1].Value = model.SBXXID;
parameters[2].Value = model.HZLX;
parameters[3].Value = model.NSRSBH;
parameters[4].Value = model.NSRMC;
parameters[5].Value = model.SWJGMC;
parameters[6].Value = model.YHDM;
parameters[7].Value = model.YHZH;
parameters[8].Value = model.KKFSSJ;
parameters[9].Value = model.KKCLSJ;
parameters[10].Value = model.JYLSH;
parameters[11].Value = model.DZYZData;
parameters[12].Value = model.SBWJ;
parameters[13].Value = model.SBZL;
parameters[14].Value = model.TSXX;
parameters[15].Value = model.ZT;
parameters[16].Value = model.ZJE;
parameters[17].Value = model.KKJE;
parameters[18].Value = model.WJJE;
parameters[19].Value = model.SBZLMC;
parameters[20].Value = model.SBCS;
parameters[21].Value = model.SSQQ;
parameters[22].Value = model.SSQZ;
parameters[23].Value = model.KKSJ;
parameters[24].Value = model.SBFKYZM;
parameters[25].Value = model.FKDM;
parameters[26].Value = model.FKXX;
parameters[27].Value = model.SZ;
parameters[28].Value = model.FileName;
parameters[29].Value = model.MW;
SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
