/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(tdps.Model.SBCL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(FID) from SBCL");
strSql.Append(" where FileName=@FileName or SBXXID =@SBXXID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@SBXXID", DbType.Int32, 4),
new SQLiteParameter("@FileName", DbType.String, 200)
};
parameters[0].Value = model.SBXXID;
parameters[1].Value = model.FileName;
return(SQLiteHelper.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(tdps.Model.SBCL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SBCL(");
strSql.Append("SBXXID,HZLX,NSRSBH,NSRMC,SWJGMC,SBFSSJ,SBCLSJ,JYLSH,JMM,DZYZData,SBWJ,SBBZLMC,SBZL,SBSE,TSXX,SBCS,SSQQ,SSQZ,MW,SZ,FKDM,FKXX,FKSJ,FileName)");
strSql.Append(" values (");
strSql.Append("@SBXXID,@HZLX,@NSRSBH,@NSRMC,@SWJGMC,@SBFSSJ,@SBCLSJ,@JYLSH,@JMM,@DZYZData,@SBWJ,@SBBZLMC,@SBZL,@SBSE,@TSXX,@SBCS,@SSQQ,@SSQZ,@MW,@SZ,@FKDM,@FKXX,@FKSJ,@FileName)");
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("@SBFSSJ", DbType.String, 20),
new SQLiteParameter("@SBCLSJ", DbType.String, 20),
new SQLiteParameter("@JYLSH", DbType.String, 30),
new SQLiteParameter("@JMM", DbType.String, 30),
new SQLiteParameter("@DZYZData", DbType.String),
new SQLiteParameter("@SBWJ", DbType.String, 100),
new SQLiteParameter("@SBBZLMC", DbType.String, 80),
new SQLiteParameter("@SBZL", DbType.String, 20),
new SQLiteParameter("@SBSE", DbType.Decimal, 9),
new SQLiteParameter("@TSXX", DbType.String),
new SQLiteParameter("@SBCS", DbType.Int32, 4),
new SQLiteParameter("@SSQQ", DbType.String, 20),
new SQLiteParameter("@SSQZ", DbType.String, 20),
new SQLiteParameter("@MW", DbType.String),
new SQLiteParameter("@SZ", DbType.String, 20),
new SQLiteParameter("@FKDM", DbType.String, 20),
new SQLiteParameter("@FKXX", DbType.String),
new SQLiteParameter("@FKSJ", DbType.String, 20),
new SQLiteParameter("@FileName", DbType.String, 200)
};
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.SBFSSJ;
parameters[6].Value = model.SBCLSJ;
parameters[7].Value = model.JYLSH;
parameters[8].Value = model.JMM;
parameters[9].Value = model.DZYZData;
parameters[10].Value = model.SBWJ;
parameters[11].Value = model.SBBZLMC;
parameters[12].Value = model.SBZL;
parameters[13].Value = model.SBSE;
parameters[14].Value = model.TSXX;
parameters[15].Value = model.SBCS;
parameters[16].Value = model.SSQQ;
parameters[17].Value = model.SSQZ;
parameters[18].Value = model.MW;
parameters[19].Value = model.SZ;
parameters[20].Value = model.FKDM;
parameters[21].Value = model.FKXX;
parameters[22].Value = model.FKSJ;
parameters[23].Value = model.FileName;
SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tdps.Model.SBCL GetModel(int FID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select FID,SBXXID,HZLX,NSRSBH,NSRMC,SWJGMC,SBFSSJ,SBCLSJ,JYLSH,JMM,DZYZData,SBWJ,SBBZLMC,SBZL,SBSE,TSXX,SBCS,SSQQ,SSQZ,MW,SZ,FKDM,FKXX,FKSJ,FileName from SBCL ");
strSql.Append(" where FID=@FID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@FID", DbType.Int32, 4)
};
parameters[0].Value = FID;
tdps.Model.SBCL model = new tdps.Model.SBCL();
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.SBFSSJ = ds.Tables[0].Rows[0]["SBFSSJ"].ToString();
model.SBCLSJ = ds.Tables[0].Rows[0]["SBCLSJ"].ToString();
model.JYLSH = ds.Tables[0].Rows[0]["JYLSH"].ToString();
model.JMM = ds.Tables[0].Rows[0]["JMM"].ToString();
model.DZYZData = ds.Tables[0].Rows[0]["DZYZData"].ToString();
model.SBWJ = ds.Tables[0].Rows[0]["SBWJ"].ToString();
model.SBBZLMC = ds.Tables[0].Rows[0]["SBBZLMC"].ToString();
model.SBZL = ds.Tables[0].Rows[0]["SBZL"].ToString();
if (ds.Tables[0].Rows[0]["SBSE"].ToString() != "")
{
model.SBSE = decimal.Parse(ds.Tables[0].Rows[0]["SBSE"].ToString());
}
model.TSXX = ds.Tables[0].Rows[0]["TSXX"].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.MW = ds.Tables[0].Rows[0]["MW"].ToString();
model.SZ = ds.Tables[0].Rows[0]["SZ"].ToString();
model.FKDM = ds.Tables[0].Rows[0]["FKDM"].ToString();
model.FKXX = ds.Tables[0].Rows[0]["FKXX"].ToString();
model.FKSJ = ds.Tables[0].Rows[0]["FKSJ"].ToString();
model.FileName = ds.Tables[0].Rows[0]["FileName"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(tdps.Model.SBCL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SBCL set ");
strSql.Append("SBXXID=@SBXXID,");
strSql.Append("HZLX=@HZLX,");
strSql.Append("NSRSBH=@NSRSBH,");
strSql.Append("NSRMC=@NSRMC,");
strSql.Append("SWJGMC=@SWJGMC,");
strSql.Append("SBFSSJ=@SBFSSJ,");
strSql.Append("SBCLSJ=@SBCLSJ,");
strSql.Append("JYLSH=@JYLSH,");
strSql.Append("JMM=@JMM,");
strSql.Append("DZYZData=@DZYZData,");
strSql.Append("SBWJ=@SBWJ,");
strSql.Append("SBBZLMC=@SBBZLMC,");
strSql.Append("SBZL=@SBZL,");
strSql.Append("SBSE=@SBSE,");
strSql.Append("TSXX=@TSXX,");
strSql.Append("SBCS=@SBCS,");
strSql.Append("SSQQ=@SSQQ,");
strSql.Append("SSQZ=@SSQZ,");
strSql.Append("MW=@MW,");
strSql.Append("SZ=@SZ,");
strSql.Append("FKDM=@FKDM,");
strSql.Append("FKXX=@FKXX,");
strSql.Append("FKSJ=@FKSJ,");
strSql.Append("FileName=@FileName");
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("@SBFSSJ", DbType.String, 20),
new SQLiteParameter("@SBCLSJ", DbType.String, 20),
new SQLiteParameter("@JYLSH", DbType.String, 30),
new SQLiteParameter("@JMM", DbType.String, 30),
new SQLiteParameter("@DZYZData", DbType.String),
new SQLiteParameter("@SBWJ", DbType.String, 100),
new SQLiteParameter("@SBBZLMC", DbType.String, 80),
new SQLiteParameter("@SBZL", DbType.String, 20),
new SQLiteParameter("@SBSE", DbType.Decimal, 9),
new SQLiteParameter("@TSXX", DbType.String),
new SQLiteParameter("@SBCS", DbType.Int32, 4),
new SQLiteParameter("@SSQQ", DbType.String, 20),
new SQLiteParameter("@SSQZ", DbType.String, 20),
new SQLiteParameter("@MW", DbType.String),
new SQLiteParameter("@SZ", DbType.String, 20),
new SQLiteParameter("@FKDM", DbType.String, 20),
new SQLiteParameter("@FKXX", DbType.String),
new SQLiteParameter("@FKSJ", DbType.String, 20),
new SQLiteParameter("@FileName", DbType.String, 200)
};
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.SBFSSJ;
parameters[7].Value = model.SBCLSJ;
parameters[8].Value = model.JYLSH;
parameters[9].Value = model.JMM;
parameters[10].Value = model.DZYZData;
parameters[11].Value = model.SBWJ;
parameters[12].Value = model.SBBZLMC;
parameters[13].Value = model.SBZL;
parameters[14].Value = model.SBSE;
parameters[15].Value = model.TSXX;
parameters[16].Value = model.SBCS;
parameters[17].Value = model.SSQQ;
parameters[18].Value = model.SSQZ;
parameters[19].Value = model.MW;
parameters[20].Value = model.SZ;
parameters[21].Value = model.FKDM;
parameters[22].Value = model.FKXX;
parameters[23].Value = model.FKSJ;
parameters[24].Value = model.FileName;
SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
