Exemple #1
0
        /// <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);
        }
Exemple #2
0
        /// <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);
        }
Exemple #3
0
        /// <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);
            }
        }
Exemple #4
0
        /// <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);
        }