/// <summary> /// 更新一条数据 /// </summary> public void Update(tdps.Model.YWSLJG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update YWSLJG set "); strSql.Append("FileName=@FileName,"); strSql.Append("returnCode=@returnCode,"); strSql.Append("returnMessage=@returnMessage,"); strSql.Append("businessID=@businessID,"); strSql.Append("jmm=@jmm,"); strSql.Append("NSRSBH=@NSRSBH,"); strSql.Append("NSRMC=@NSRMC,"); strSql.Append("createTime=@createTime,"); strSql.Append("SWJGDM=@SWJGDM,"); strSql.Append("JYSLXX=@JYSLXX,"); strSql.Append("swjgMc=@swjgMc,"); strSql.Append("DZYZData=@DZYZData,"); strSql.Append("MW=@MW,"); strSql.Append("SLLX=@SLLX,"); strSql.Append("KHDFSSJ=@KHDFSSJ"); strSql.Append(" where FID=@FID "); SQLiteParameter[] parameters = { new SQLiteParameter("@FID", DbType.Int32, 4), new SQLiteParameter("@FileName", DbType.String, 50), new SQLiteParameter("@returnCode", DbType.String, 8), new SQLiteParameter("@returnMessage", DbType.String, 50), new SQLiteParameter("@businessID", DbType.String, 20), new SQLiteParameter("@jmm", DbType.String, 20), new SQLiteParameter("@NSRSBH", DbType.String, 20), new SQLiteParameter("@NSRMC", DbType.String, 80), new SQLiteParameter("@createTime", DbType.String, 20), new SQLiteParameter("@SWJGDM", DbType.String, 20), new SQLiteParameter("@JYSLXX", DbType.String), new SQLiteParameter("@swjgMc", DbType.String, 20), new SQLiteParameter("@DZYZData", DbType.String), new SQLiteParameter("@MW", DbType.String), new SQLiteParameter("@SLLX", DbType.String, 20), new SQLiteParameter("@KHDFSSJ", DbType.String, 20) }; parameters[0].Value = model.FID; parameters[1].Value = model.FileName; parameters[2].Value = model.returnCode; parameters[3].Value = model.returnMessage; parameters[4].Value = model.businessID; parameters[5].Value = model.jmm; parameters[6].Value = model.NSRSBH; parameters[7].Value = model.NSRMC; parameters[8].Value = model.createTime; parameters[9].Value = model.SWJGDM; parameters[10].Value = model.JYSLXX; parameters[11].Value = model.swjgMc; parameters[12].Value = model.DZYZData; parameters[13].Value = model.MW; parameters[14].Value = model.SLLX; parameters[15].Value = model.KHDFSSJ; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(tdps.Model.YWSLJG model, object trans) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YWSLJG("); strSql.Append("FileName,returnCode,returnMessage,businessID,jmm,NSRSBH,NSRMC,createTime,SWJGDM,JYSLXX,swjgMc,DZYZData,MW,SLLX,KHDFSSJ,SSQQ,SSQZ,ZSXM_DM,ZSXM_MC,ZSPM_DM,ZSPM_MC)"); strSql.Append(" values ("); strSql.Append("@FileName,@returnCode,@returnMessage,@businessID,@jmm,@NSRSBH,@NSRMC,@createTime,@SWJGDM,@JYSLXX,@swjgMc,@DZYZData,@MW,@SLLX,@KHDFSSJ,@SSQQ,@SSQZ,@ZSXM_DM,@ZSXM_MC,@ZSPM_DM,@ZSPM_MC)"); SQLiteParameter[] parameters = { new SQLiteParameter("@FileName", DbType.String, 50), new SQLiteParameter("@returnCode", DbType.String, 8), new SQLiteParameter("@returnMessage", DbType.String, 50), new SQLiteParameter("@businessID", DbType.String, 20), new SQLiteParameter("@jmm", DbType.String, 20), new SQLiteParameter("@NSRSBH", DbType.String, 20), new SQLiteParameter("@NSRMC", DbType.String, 80), new SQLiteParameter("@createTime", DbType.String, 20), new SQLiteParameter("@SWJGDM", DbType.String, 20), new SQLiteParameter("@JYSLXX", DbType.String), new SQLiteParameter("@swjgMc", DbType.String, 20), new SQLiteParameter("@DZYZData", DbType.String), new SQLiteParameter("@MW", DbType.String), new SQLiteParameter("@SLLX", DbType.String, 20), new SQLiteParameter("@KHDFSSJ", DbType.String, 20), new SQLiteParameter("@SSQQ", DbType.String), new SQLiteParameter("@SSQZ", DbType.String, 20), new SQLiteParameter("@ZSXM_DM", DbType.String), new SQLiteParameter("@ZSXM_MC", DbType.String), new SQLiteParameter("@ZSPM_DM", DbType.String, 20), new SQLiteParameter("@ZSPM_MC", DbType.String, 20) }; parameters[0].Value = model.FileName; parameters[1].Value = model.returnCode; parameters[2].Value = model.returnMessage; parameters[3].Value = model.businessID; parameters[4].Value = model.jmm; parameters[5].Value = model.NSRSBH; parameters[6].Value = model.NSRMC; parameters[7].Value = model.createTime; parameters[8].Value = model.SWJGDM; parameters[9].Value = model.JYSLXX; parameters[10].Value = model.swjgMc; parameters[11].Value = model.DZYZData; parameters[12].Value = model.MW; parameters[13].Value = model.SLLX; parameters[14].Value = model.KHDFSSJ; parameters[15].Value = model.ssqq; parameters[16].Value = model.ssqz; parameters[17].Value = model.zsxm_dm; parameters[18].Value = model.zsxm_mc; parameters[19].Value = model.zspm_dm; parameters[20].Value = model.zspm_mc; SQLiteHelper.ExecuteNonQueryByTransaction(strSql.ToString(), (SQLiteTransaction)trans, parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public tdps.Model.YWSLJG GetModel(int FID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select FID,FileName,returnCode,returnMessage,businessID,jmm,NSRSBH,NSRMC,createTime,SWJGDM,JYSLXX,swjgMc,DZYZData,MW,SLLX,KHDFSSJ,ZSXM_DM,ZSXM_MC,ZSPM_DM,ZSPM_MC,SSQQ,SSQZ from YWSLJG "); strSql.Append(" where FID=@FID "); SQLiteParameter[] parameters = { new SQLiteParameter("@FID", DbType.Int32, 4) }; parameters[0].Value = FID; tdps.Model.YWSLJG model = new tdps.Model.YWSLJG(); 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()); } model.FileName = ds.Tables[0].Rows[0]["FileName"].ToString(); model.returnCode = ds.Tables[0].Rows[0]["returnCode"].ToString(); model.returnMessage = ds.Tables[0].Rows[0]["returnMessage"].ToString(); model.businessID = ds.Tables[0].Rows[0]["businessID"].ToString(); model.jmm = ds.Tables[0].Rows[0]["jmm"].ToString(); model.NSRSBH = ds.Tables[0].Rows[0]["NSRSBH"].ToString(); model.NSRMC = ds.Tables[0].Rows[0]["NSRMC"].ToString(); model.createTime = ds.Tables[0].Rows[0]["createTime"].ToString(); model.SWJGDM = ds.Tables[0].Rows[0]["SWJGDM"].ToString(); model.JYSLXX = ds.Tables[0].Rows[0]["JYSLXX"].ToString(); model.swjgMc = ds.Tables[0].Rows[0]["swjgMc"].ToString(); model.DZYZData = ds.Tables[0].Rows[0]["DZYZData"].ToString(); model.MW = ds.Tables[0].Rows[0]["MW"].ToString(); model.SLLX = ds.Tables[0].Rows[0]["SLLX"].ToString(); model.KHDFSSJ = ds.Tables[0].Rows[0]["KHDFSSJ"].ToString(); model.ssqq = ds.Tables[0].Rows[0]["SSQQ"].ToString(); model.ssqz = ds.Tables[0].Rows[0]["SSQZ"].ToString(); model.zspm_dm = ds.Tables[0].Rows[0]["ZSPM_DM"].ToString(); model.zspm_mc = ds.Tables[0].Rows[0]["ZSPM_MC"].ToString(); model.zsxm_dm = ds.Tables[0].Rows[0]["ZSXM_DM"].ToString(); model.zsxm_mc = ds.Tables[0].Rows[0]["ZSXM_MC"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(tdps.Model.YWSLJG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YWSLJG("); strSql.Append("FileName,returnCode,returnMessage,businessID,jmm,NSRSBH,NSRMC,createTime,SWJGDM,JYSLXX,swjgMc,DZYZData,MW,SLLX,KHDFSSJ)"); strSql.Append(" values ("); strSql.Append("@FileName,@returnCode,@returnMessage,@businessID,@jmm,@NSRSBH,@NSRMC,@createTime,@SWJGDM,@JYSLXX,@swjgMc,@DZYZData,@MW,@SLLX,@KHDFSSJ)"); SQLiteParameter[] parameters = { new SQLiteParameter("@FileName", DbType.String, 50), new SQLiteParameter("@returnCode", DbType.String, 8), new SQLiteParameter("@returnMessage", DbType.String, 50), new SQLiteParameter("@businessID", DbType.String, 20), new SQLiteParameter("@jmm", DbType.String, 20), new SQLiteParameter("@NSRSBH", DbType.String, 20), new SQLiteParameter("@NSRMC", DbType.String, 80), new SQLiteParameter("@createTime", DbType.String, 20), new SQLiteParameter("@SWJGDM", DbType.String, 20), new SQLiteParameter("@JYSLXX", DbType.String), new SQLiteParameter("@swjgMc", DbType.String, 20), new SQLiteParameter("@DZYZData", DbType.String), new SQLiteParameter("@MW", DbType.String), new SQLiteParameter("@SLLX", DbType.String, 20), new SQLiteParameter("@KHDFSSJ", DbType.String, 20) }; parameters[0].Value = model.FileName; parameters[1].Value = model.returnCode; parameters[2].Value = model.returnMessage; parameters[3].Value = model.businessID; parameters[4].Value = model.jmm; parameters[5].Value = model.NSRSBH; parameters[6].Value = model.NSRMC; parameters[7].Value = model.createTime; parameters[8].Value = model.SWJGDM; parameters[9].Value = model.JYSLXX; parameters[10].Value = model.swjgMc; parameters[11].Value = model.DZYZData; parameters[12].Value = model.MW; parameters[13].Value = model.SLLX; parameters[14].Value = model.KHDFSSJ; SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); }