예제 #1
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("id", "t_unit_goods"));
 }
예제 #2
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("Id", "blogcommentarticle"));
 }
예제 #3
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Jium.Model.servicerorder model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update servicerorder set ");
            strSql.Append("ccode=@ccode,");
            strSql.Append("spid=@spid,");
            strSql.Append("spnum=@spnum,");
            strSql.Append("spspan=@spspan,");
            strSql.Append("sostatus=@sostatus,");
            strSql.Append("createtime=@createtime,");
            strSql.Append("updatetime=@updatetime,");
            strSql.Append("updateby=@updateby,");
            strSql.Append("sos1=@sos1,");
            strSql.Append("sos2=@sos2,");
            strSql.Append("sos3=@sos3,");
            strSql.Append("sos4=@sos4,");
            strSql.Append("sos5=@sos5,");
            strSql.Append("sod1=@sod1,");
            strSql.Append("sod2=@sod2,");
            strSql.Append("sod3=@sod3,");
            strSql.Append("sod4=@sod4,");
            strSql.Append("sod5=@sod5");
            strSql.Append(" where id=@id");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@ccode",      MySqlDbType.VarChar, 40),
                new MySqlParameter("@spid",       MySqlDbType.VarChar, 20),
                new MySqlParameter("@spnum",      MySqlDbType.Int32,   11),
                new MySqlParameter("@spspan",     MySqlDbType.Int32,   11),
                new MySqlParameter("@sostatus",   MySqlDbType.Int32,   11),
                new MySqlParameter("@createtime", MySqlDbType.VarChar, 20),
                new MySqlParameter("@updatetime", MySqlDbType.VarChar, 20),
                new MySqlParameter("@updateby",   MySqlDbType.VarChar, 40),
                new MySqlParameter("@sos1",       MySqlDbType.VarChar, 40),
                new MySqlParameter("@sos2",       MySqlDbType.VarChar, 40),
                new MySqlParameter("@sos3",       MySqlDbType.VarChar, 40),
                new MySqlParameter("@sos4",       MySqlDbType.VarChar, 40),
                new MySqlParameter("@sos5",       MySqlDbType.VarChar, 40),
                new MySqlParameter("@sod1",       MySqlDbType.Int32,   11),
                new MySqlParameter("@sod2",       MySqlDbType.Int32,   11),
                new MySqlParameter("@sod3",       MySqlDbType.Int32,   11),
                new MySqlParameter("@sod4",       MySqlDbType.Int32,   11),
                new MySqlParameter("@sod5",       MySqlDbType.Int32,   11),
                new MySqlParameter("@id",         MySqlDbType.Int64, 20)
            };
            parameters[0].Value  = model.ccode;
            parameters[1].Value  = model.spid;
            parameters[2].Value  = model.spnum;
            parameters[3].Value  = model.spspan;
            parameters[4].Value  = model.sostatus;
            parameters[5].Value  = model.createtime;
            parameters[6].Value  = model.updatetime;
            parameters[7].Value  = model.updateby;
            parameters[8].Value  = model.sos1;
            parameters[9].Value  = model.sos2;
            parameters[10].Value = model.sos3;
            parameters[11].Value = model.sos4;
            parameters[12].Value = model.sos5;
            parameters[13].Value = model.sod1;
            parameters[14].Value = model.sod2;
            parameters[15].Value = model.sod3;
            parameters[16].Value = model.sod4;
            parameters[17].Value = model.sod5;
            parameters[18].Value = model.id;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #4
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("Id", "crm_set_pubpri"));
 }
예제 #5
0
        /// <summary>
        /// 检测生成众生争霸排行榜
        /// </summary>
        /// <param name="now"></param>
        private bool CheckBuildZhengBaRank(int selectRoleIfNewCreate, int nowMonth)
        {
            bool bMonthFirst = false;

            try
            {
                DbHelperMySQL.ExecuteSql(
                    string.Format("INSERT IGNORE INTO t_async(`id`,`value`) VALUES({0},{1});",
                                  AsyncTypes.ZhengBaCurrMonth, ZhengBaConsts.DefaultAsyncMonth)
                    );

                // 防止人为的重新reload月排行榜导致众神争霸战斗信息丢失

                /* 这里有一些细节要注意:
                 * 1:每月1号凌晨3点更新月排行榜,然后触发更新争霸角色
                 * 2: 服务器启动的时候,尝试生成争霸角色
                 * 3:要防止当月的争霸角色重复生成
                 * 4:必须保证天梯排行角色已经生成,才能生成争霸角色 -->例如,1号凌晨两点启动,必须保证等到3点的时候,天梯月排行榜生成之后,能够生成本月的争霸角色
                 */
                int    oldMonth           = (int)DbHelperMySQL.GetSingle("select value from t_async where id = " + AsyncTypes.ZhengBaCurrMonth);
                object ageObj_tiantiMonth = DbHelperMySQL.GetSingle("select value from t_async where id = " + AsyncTypes.TianTiPaiHangModifyOffsetDay);
                if (oldMonth != nowMonth &&
                    ageObj_tiantiMonth != null &&
                    ZhengBaUtils.MakeMonth(DataHelper2.GetRealDate((int)ageObj_tiantiMonth)) == nowMonth)
                {
                    string strSql = string.Format("SELECT rid,rname,zoneid,duanweiid,duanweijifen,duanweirank,zhanli,data1,data2 FROM t_tianti_month_paihang ORDER BY duanweirank ASC LIMIT {0};", selectRoleIfNewCreate);
                    var    sdr    = DbHelperMySQL.ExecuteReader(strSql);
                    while (sdr != null && sdr.Read())
                    {
                        ZhengBaRoleInfoData roleData = new ZhengBaRoleInfoData();
                        roleData.RoleId       = (int)Convert.ToInt32(sdr["rid"]);
                        roleData.ZoneId       = (int)Convert.ToInt32(sdr["zoneid"]);
                        roleData.DuanWeiId    = (int)Convert.ToInt32(sdr["duanweiid"]);
                        roleData.DuanWeiJiFen = (int)Convert.ToInt32(sdr["duanweijifen"]);
                        roleData.DuanWeiRank  = (int)Convert.ToInt32(sdr["duanweirank"]);
                        roleData.ZhanLi       = (int)Convert.ToInt32(sdr["zhanli"]);
                        roleData.RoleName     = sdr["rname"].ToString();
                        if (!sdr.IsDBNull(sdr.GetOrdinal("data1")))
                        {
                            roleData.TianTiPaiHangRoleData = (byte[])(sdr["data1"]);
                        }
                        if (!sdr.IsDBNull(sdr.GetOrdinal("data2")))
                        {
                            roleData.PlayerJingJiMirrorData = (byte[])(sdr["data2"]);
                        }
                        if (string.IsNullOrEmpty(roleData.RoleName) && roleData.TianTiPaiHangRoleData != null)
                        {
                            var onlyName = DataHelper2.BytesToObject <TianTiPaiHangRoleData_OnlyName>(
                                roleData.TianTiPaiHangRoleData, 0, roleData.TianTiPaiHangRoleData.Length);
                            if (onlyName != null)
                            {
                                roleData.RoleName = onlyName.RoleName;
                            }
                        }

                        string repSql = string.Format(
                            "REPLACE INTO t_zhengba_roles(`month`,rid,zoneid,duanweiid,duanweijifen,duanweirank,zhanli,`grade`,`group`,state,rname,data1,data2) "
                            + "VALUES({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},'{10}',@content,@mirror)",
                            nowMonth, roleData.RoleId, roleData.ZoneId, roleData.DuanWeiId,
                            roleData.DuanWeiJiFen, roleData.DuanWeiRank, roleData.ZhanLi,
                            (int)EZhengBaGrade.Grade100, (int)ZhengBaConsts.NoneGroup, (int)EZhengBaState.None, roleData.RoleName);

                        DbHelperMySQL.ExecuteSqlInsertImg(repSql,
                                                          new List <Tuple <string, byte[]> > {
                            new Tuple <string, byte[]>("content", roleData.TianTiPaiHangRoleData),
                            new Tuple <string, byte[]>("mirror", roleData.PlayerJingJiMirrorData)
                        });
                    }
                    if (sdr != null)
                    {
                        sdr.Close();
                    }

                    DbHelperMySQL.ExecuteSql(
                        string.Format("REPLACE INTO t_async(`id`,`value`) VALUES({0},{1});",
                                      AsyncTypes.ZhengBaCurrMonth, nowMonth)
                        );

                    bMonthFirst = true;
                }
            }
            catch (Exception ex)
            {
                LogManager.WriteExceptionUseCache(ex.ToString());
            }

            return(bMonthFirst);
        }
예제 #6
0
        /// <summary>
        /// 根据字段列表,条件,排序,读取记录
        /// </summary>
        /// <param name="columslist">字段列表,如:Id,姓名,性别,年龄</param>
        /// <param name="strWhere">条件,如:年龄>12 and 性别='女'</param>
        /// <param name="filedOrder">排序,如: Id desc </param>
        /// <returns>返回组装好的json字符串</returns>
        public string GetListByColumns_tojson(string columslist, string strWhere, string orderby)
        {
            string str = DbHelperMySQL.GetListByColumns_tojson(columslist, strWhere, orderby, "tb_navigation");

            return(str);
        }
예제 #7
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Maticsoft.Model.ps_outfall model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update ps_outfall set ");
            strSql.Append("Prj_No=@Prj_No,");
            strSql.Append("Prj_Name=@Prj_Name,");
            strSql.Append("MapCode=@MapCode,");
            strSql.Append("SewageSystem_ID=@SewageSystem_ID,");
            strSql.Append("StormSystem_ID=@StormSystem_ID,");
            strSql.Append("Type=@Type,");
            strSql.Append("X=@X,");
            strSql.Append("Y=@Y,");
            strSql.Append("High=@High,");
            strSql.Append("Bottom_Elev=@Bottom_Elev,");
            strSql.Append("OutfallShape=@OutfallShape,");
            strSql.Append("OutfallType=@OutfallType,");
            strSql.Append("Offset=@Offset,");
            strSql.Append("Rotation=@Rotation,");
            strSql.Append("Code=@Code,");
            strSql.Append("Flap=@Flap,");
            strSql.Append("Flap_Diameter=@Flap_Diameter,");
            strSql.Append("Flap_TopEle=@Flap_TopEle,");
            strSql.Append("Flap_BotEle=@Flap_BotEle,");
            strSql.Append("Flap_Materail=@Flap_Materail,");
            strSql.Append("Receive=@Receive,");
            strSql.Append("Address=@Address,");
            strSql.Append("PointPosition=@PointPosition,");
            strSql.Append("DataSource=@DataSource,");
            strSql.Append("Visibility=@Visibility,");
            strSql.Append("Sunit=@Sunit,");
            strSql.Append("Sdate=@Sdate,");
            strSql.Append("UpdateTime=@UpdateTime,");
            strSql.Append("Mdate=@Mdate,");
            strSql.Append("Outfall_Type=@Outfall_Type,");
            strSql.Append("Status=@Status,");
            strSql.Append("Ename=@Ename,");
            strSql.Append("Design_Dept=@Design_Dept,");
            strSql.Append("Conster_Dept=@Conster_Dept,");
            strSql.Append("Belong=@Belong,");
            strSql.Append("Operator=@Operator,");
            strSql.Append("Note=@Note,");
            strSql.Append("Exp_NoOri=@Exp_NoOri,");
            strSql.Append("FileName=@FileName,");
            strSql.Append("Uploadtime=@Uploadtime");
            strSql.Append(" where Exp_No=@Exp_No ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Prj_No",          MySqlDbType.VarChar, 255),
                new MySqlParameter("@Prj_Name",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@MapCode",         MySqlDbType.VarChar,  10),
                new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar,  50),
                new MySqlParameter("@StormSystem_ID",  MySqlDbType.VarChar,  50),
                new MySqlParameter("@Type",            MySqlDbType.VarChar,   4),
                new MySqlParameter("@X",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@Y",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@High",            MySqlDbType.Decimal,  10),
                new MySqlParameter("@Bottom_Elev",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@OutfallShape",    MySqlDbType.VarChar,  50),
                new MySqlParameter("@OutfallType",     MySqlDbType.VarChar,  10),
                new MySqlParameter("@Offset",          MySqlDbType.VarChar,  50),
                new MySqlParameter("@Rotation",        MySqlDbType.Decimal,   7),
                new MySqlParameter("@Code",            MySqlDbType.VarChar,  10),
                new MySqlParameter("@Flap",            MySqlDbType.VarChar,  10),
                new MySqlParameter("@Flap_Diameter",   MySqlDbType.Decimal,   7),
                new MySqlParameter("@Flap_TopEle",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@Flap_BotEle",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@Flap_Materail",   MySqlDbType.VarChar,  50),
                new MySqlParameter("@Receive",         MySqlDbType.VarChar,  50),
                new MySqlParameter("@Address",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@PointPosition",   MySqlDbType.Int32,    10),
                new MySqlParameter("@DataSource",      MySqlDbType.VarChar,  10),
                new MySqlParameter("@Visibility",      MySqlDbType.VarChar,   4),
                new MySqlParameter("@Sunit",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@Sdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@UpdateTime",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@Mdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@Outfall_Type",    MySqlDbType.VarChar,  10),
                new MySqlParameter("@Status",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Ename",           MySqlDbType.VarChar, 100),
                new MySqlParameter("@Design_Dept",     MySqlDbType.VarChar, 255),
                new MySqlParameter("@Conster_Dept",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@Belong",          MySqlDbType.VarChar, 255),
                new MySqlParameter("@Operator",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Note",            MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_NoOri",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@FileName",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Uploadtime",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_No",          MySqlDbType.VarChar, 100)
            };
            parameters[0].Value  = model.Prj_No;
            parameters[1].Value  = model.Prj_Name;
            parameters[2].Value  = model.MapCode;
            parameters[3].Value  = model.SewageSystem_ID;
            parameters[4].Value  = model.StormSystem_ID;
            parameters[5].Value  = model.Type;
            parameters[6].Value  = model.X;
            parameters[7].Value  = model.Y;
            parameters[8].Value  = model.High;
            parameters[9].Value  = model.Bottom_Elev;
            parameters[10].Value = model.OutfallShape;
            parameters[11].Value = model.OutfallType;
            parameters[12].Value = model.Offset;
            parameters[13].Value = model.Rotation;
            parameters[14].Value = model.Code;
            parameters[15].Value = model.Flap;
            parameters[16].Value = model.Flap_Diameter;
            parameters[17].Value = model.Flap_TopEle;
            parameters[18].Value = model.Flap_BotEle;
            parameters[19].Value = model.Flap_Materail;
            parameters[20].Value = model.Receive;
            parameters[21].Value = model.Address;
            parameters[22].Value = model.PointPosition;
            parameters[23].Value = model.DataSource;
            parameters[24].Value = model.Visibility;
            parameters[25].Value = model.Sunit;
            parameters[26].Value = model.Sdate;
            parameters[27].Value = model.UpdateTime;
            parameters[28].Value = model.Mdate;
            parameters[29].Value = model.Outfall_Type;
            parameters[30].Value = model.Status;
            parameters[31].Value = model.Ename;
            parameters[32].Value = model.Design_Dept;
            parameters[33].Value = model.Conster_Dept;
            parameters[34].Value = model.Belong;
            parameters[35].Value = model.Operator;
            parameters[36].Value = model.Note;
            parameters[37].Value = model.Exp_NoOri;
            parameters[38].Value = model.FileName;
            parameters[39].Value = model.Uploadtime;
            parameters[40].Value = model.Exp_No;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Adds(XHD.Model.scm_authority_dtcolumn model)
        {
            List <string> strSqlList = new List <string>();

            string[] menu_ids = model.Menu_ids.Split(',');

            string[] column_ids;
            string   strSql = string.Empty;

            string ids = model.column_ids.Replace(",", "");

            if (!string.IsNullOrEmpty(ids))
            {
                foreach (var item in menu_ids)
                {
                    if (!string.IsNullOrEmpty(item))
                    {
                        //查询该页面下的列
                        DataSet ds = GetListColumn("Menu_id='" + item + "'");
                        if (ds != null && ds.Tables[0].Rows.Count > 0)
                        {
                            string columnIds = model.column_ids.Substring(2, model.column_ids.Length - 3);

                            if (columnIds.Length > 2)
                            {
                                string s = string.Empty;
                                column_ids = columnIds.Split(',');
                                foreach (var items in column_ids)
                                {
                                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                                    {
                                        int column_id = Convert.ToInt32(ds.Tables[0].Rows[i]["column_id"].ToString());
                                        if (column_id == Convert.ToInt32(items))
                                        {
                                            s += items + ",";
                                            break;
                                        }
                                    }
                                }
                                strSql = string.Format(@"insert into scm_authority_dtcolumn (factory_Id,suppliers_id,Menu_ids,column_ids,Create_id,Create_date)
                                            values('{0}','{1}','{2}','{3}','{4}','{5}')", model.factory_Id, model.suppliers_id, item, s, model.Create_id, model.Create_date);
                                strSqlList.Add(strSql);
                            }
                            else
                            {
                                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                                {
                                    int column_id = Convert.ToInt32(ds.Tables[0].Rows[i]["column_id"].ToString());
                                    if (column_id == Convert.ToInt32(columnIds))
                                    {
                                        strSql = string.Format(@"insert into scm_authority_dtcolumn (factory_Id,suppliers_id,Menu_ids,column_ids,Create_id,Create_date)
                                            values('{0}','{1}','{2}','{3}','{4}','{5}')", model.factory_Id, model.suppliers_id, item, columnIds, model.Create_id, model.Create_date);
                                        strSqlList.Add(strSql);
                                    }
                                }
                            }
                        }
                    }
                }
            }

            int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #9
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Maticsoft.Model.ps_retention model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update ps_retention set ");
            strSql.Append("Prj_No=@Prj_No,");
            strSql.Append("Prj_Name=@Prj_Name,");
            strSql.Append("MapCode=@MapCode,");
            strSql.Append("Name=@Name,");
            strSql.Append("SewageSystem_ID=@SewageSystem_ID,");
            strSql.Append("StormSystem_ID=@StormSystem_ID,");
            strSql.Append("Type=@Type,");
            strSql.Append("X=@X,");
            strSql.Append("Y=@Y,");
            strSql.Append("High=@High,");
            strSql.Append("Inflow_Type=@Inflow_Type,");
            strSql.Append("Outflow_Type=@Outflow_Type,");
            strSql.Append("Total_Vol=@Total_Vol,");
            strSql.Append("B_Level=@B_Level,");
            strSql.Append("Max_Level=@Max_Level,");
            strSql.Append("Min_Level=@Min_Level,");
            strSql.Append("Design_Time=@Design_Time,");
            strSql.Append("Ps_Num=@Ps_Num,");
            strSql.Append("FlowDir=@FlowDir,");
            strSql.Append("Code=@Code,");
            strSql.Append("Address=@Address,");
            strSql.Append("DataSource=@DataSource,");
            strSql.Append("Sunit=@Sunit,");
            strSql.Append("Sdate=@Sdate,");
            strSql.Append("UpdateTime=@UpdateTime,");
            strSql.Append("Mdate=@Mdate,");
            strSql.Append("DataListID=@DataListID,");
            strSql.Append("Status=@Status,");
            strSql.Append("Ename=@Ename,");
            strSql.Append("Design_Dept=@Design_Dept,");
            strSql.Append("Conster_Dept=@Conster_Dept,");
            strSql.Append("Belong=@Belong,");
            strSql.Append("Operator=@Operator,");
            strSql.Append("Note=@Note,");
            strSql.Append("Exp_NoOri=@Exp_NoOri,");
            strSql.Append("FileName=@FileName,");
            strSql.Append("Uploadtime=@Uploadtime");
            strSql.Append(" where Exp_No=@Exp_No ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Prj_No",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Prj_Name",        MySqlDbType.VarChar, 100),
                new MySqlParameter("@MapCode",         MySqlDbType.VarChar,  10),
                new MySqlParameter("@Name",            MySqlDbType.VarChar, 100),
                new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar,  50),
                new MySqlParameter("@StormSystem_ID",  MySqlDbType.VarChar,  50),
                new MySqlParameter("@Type",            MySqlDbType.VarChar,   4),
                new MySqlParameter("@X",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@Y",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@High",            MySqlDbType.Decimal,  10),
                new MySqlParameter("@Inflow_Type",     MySqlDbType.VarChar,  10),
                new MySqlParameter("@Outflow_Type",    MySqlDbType.VarChar,  10),
                new MySqlParameter("@Total_Vol",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@B_Level",         MySqlDbType.Decimal,  10),
                new MySqlParameter("@Max_Level",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@Min_Level",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@Design_Time",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@Ps_Num",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@FlowDir",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@Code",            MySqlDbType.VarChar,  10),
                new MySqlParameter("@Address",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@DataSource",      MySqlDbType.VarChar,  10),
                new MySqlParameter("@Sunit",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@Sdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@UpdateTime",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@Mdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@DataListID",      MySqlDbType.VarChar,  50),
                new MySqlParameter("@Status",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Ename",           MySqlDbType.VarChar, 100),
                new MySqlParameter("@Design_Dept",     MySqlDbType.VarChar, 255),
                new MySqlParameter("@Conster_Dept",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@Belong",          MySqlDbType.VarChar, 255),
                new MySqlParameter("@Operator",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Note",            MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_NoOri",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@FileName",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Uploadtime",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_No",          MySqlDbType.VarChar, 100)
            };
            parameters[0].Value  = model.Prj_No;
            parameters[1].Value  = model.Prj_Name;
            parameters[2].Value  = model.MapCode;
            parameters[3].Value  = model.Name;
            parameters[4].Value  = model.SewageSystem_ID;
            parameters[5].Value  = model.StormSystem_ID;
            parameters[6].Value  = model.Type;
            parameters[7].Value  = model.X;
            parameters[8].Value  = model.Y;
            parameters[9].Value  = model.High;
            parameters[10].Value = model.Inflow_Type;
            parameters[11].Value = model.Outflow_Type;
            parameters[12].Value = model.Total_Vol;
            parameters[13].Value = model.B_Level;
            parameters[14].Value = model.Max_Level;
            parameters[15].Value = model.Min_Level;
            parameters[16].Value = model.Design_Time;
            parameters[17].Value = model.Ps_Num;
            parameters[18].Value = model.FlowDir;
            parameters[19].Value = model.Code;
            parameters[20].Value = model.Address;
            parameters[21].Value = model.DataSource;
            parameters[22].Value = model.Sunit;
            parameters[23].Value = model.Sdate;
            parameters[24].Value = model.UpdateTime;
            parameters[25].Value = model.Mdate;
            parameters[26].Value = model.DataListID;
            parameters[27].Value = model.Status;
            parameters[28].Value = model.Ename;
            parameters[29].Value = model.Design_Dept;
            parameters[30].Value = model.Conster_Dept;
            parameters[31].Value = model.Belong;
            parameters[32].Value = model.Operator;
            parameters[33].Value = model.Note;
            parameters[34].Value = model.Exp_NoOri;
            parameters[35].Value = model.FileName;
            parameters[36].Value = model.Uploadtime;
            parameters[37].Value = model.Exp_No;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #10
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(DataAngineSet.Model.person model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update person set ");
            strSql.Append("person_dataset_id=@person_dataset_id,");
            strSql.Append("name=@name,");
            strSql.Append("gender=@gender,");
            strSql.Append("card_id=@card_id,");
            strSql.Append("bitrhday=@bitrhday,");
            strSql.Append("image_id=@image_id,");
            strSql.Append("face_image_path=@face_image_path,");
            strSql.Append("feature_data=@feature_data,");
            strSql.Append("type=@type,");
            strSql.Append("create_time=@create_time,");
            strSql.Append("modified_time=@modified_time,");
            strSql.Append("quality_score=@quality_score,");
            strSql.Append("remark=@remark");
            strSql.Append(" where id=@id");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@person_dataset_id", MySqlDbType.Int32,      11),
                new MySqlParameter("@name",              MySqlDbType.VarChar,    50),
                new MySqlParameter("@gender",            MySqlDbType.VarChar,     1),
                new MySqlParameter("@card_id",           MySqlDbType.VarChar,    50),
                new MySqlParameter("@bitrhday",          MySqlDbType.DateTime),
                new MySqlParameter("@image_id",          MySqlDbType.VarChar,    60),
                new MySqlParameter("@face_image_path",   MySqlDbType.VarChar,   200),
                new MySqlParameter("@feature_data",      MySqlDbType.LongBlob),
                new MySqlParameter("@type",              MySqlDbType.VarChar,     1),
                new MySqlParameter("@create_time",       MySqlDbType.DateTime),
                new MySqlParameter("@modified_time",     MySqlDbType.DateTime),
                new MySqlParameter("@quality_score",     MySqlDbType.Float),
                new MySqlParameter("@remark",            MySqlDbType.VarChar,    50),
                new MySqlParameter("@id",                MySqlDbType.Int32, 11)
            };
            parameters[0].Value  = model.person_dataset_id;
            parameters[1].Value  = model.name;
            parameters[2].Value  = model.gender;
            parameters[3].Value  = model.card_id;
            parameters[4].Value  = model.bitrhday;
            parameters[5].Value  = model.image_id;
            parameters[6].Value  = model.face_image_path;
            parameters[7].Value  = model.feature_data;
            parameters[8].Value  = model.type;
            parameters[9].Value  = model.create_time;
            parameters[10].Value = model.modified_time;
            parameters[11].Value = model.quality_score;
            parameters[12].Value = model.remark;
            parameters[13].Value = model.id;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #11
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("id", "person"));
 }
예제 #12
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("number", "pipeobjectencode"));
 }
예제 #13
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("fh_id", "fault_history"));
 }
예제 #14
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(fds.Model.fault_history model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update fault_history set ");
            strSql.Append("fh_adduser=@fh_adduser,");
            strSql.Append("ptype_id=@ptype_id,");
            strSql.Append("tpoint_id=@tpoint_id,");
            strSql.Append("system_id=@system_id,");
            strSql.Append("fh_phenomenon=@fh_phenomenon,");
            strSql.Append("fh_caseid=@fh_caseid,");
            strSql.Append("fh_title=@fh_title,");
            strSql.Append("fh_description=@fh_description,");
            strSql.Append("fh_cause=@fh_cause,");
            strSql.Append("fh_suggest=@fh_suggest,");
            strSql.Append("fh_explain=@fh_explain,");
            strSql.Append("fh_reference=@fh_reference,");
            strSql.Append("fh_experience=@fh_experience,");
            strSql.Append("fh_keywd=@fh_keywd,");
            strSql.Append("fh_addtime=@fh_addtime");
            strSql.Append(" where fh_id=@fh_id");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@fh_adduser",     MySqlDbType.Int32,       11),
                new MySqlParameter("@ptype_id",       MySqlDbType.Int32,       11),
                new MySqlParameter("@tpoint_id",      MySqlDbType.Int32,       11),
                new MySqlParameter("@system_id",      MySqlDbType.Int32,       11),
                new MySqlParameter("@fh_phenomenon",  MySqlDbType.VarChar,   2048),
                new MySqlParameter("@fh_caseid",      MySqlDbType.VarChar,    128),
                new MySqlParameter("@fh_title",       MySqlDbType.VarChar,    512),
                new MySqlParameter("@fh_description", MySqlDbType.VarChar,   2048),
                new MySqlParameter("@fh_cause",       MySqlDbType.VarChar,   2048),
                new MySqlParameter("@fh_suggest",     MySqlDbType.VarChar,   2048),
                new MySqlParameter("@fh_explain",     MySqlDbType.VarChar,   2048),
                new MySqlParameter("@fh_reference",   MySqlDbType.VarChar,   2048),
                new MySqlParameter("@fh_experience",  MySqlDbType.VarChar,   2048),
                new MySqlParameter("@fh_keywd",       MySqlDbType.VarChar,    512),
                new MySqlParameter("@fh_addtime",     MySqlDbType.DateTime),
                new MySqlParameter("@fh_id",          MySqlDbType.Int32, 11)
            };
            parameters[0].Value  = model.fh_adduser;
            parameters[1].Value  = model.ptype_id;
            parameters[2].Value  = model.tpoint_id;
            parameters[3].Value  = model.system_id;
            parameters[4].Value  = model.fh_phenomenon;
            parameters[5].Value  = model.fh_caseid;
            parameters[6].Value  = model.fh_title;
            parameters[7].Value  = model.fh_description;
            parameters[8].Value  = model.fh_cause;
            parameters[9].Value  = model.fh_suggest;
            parameters[10].Value = model.fh_explain;
            parameters[11].Value = model.fh_reference;
            parameters[12].Value = model.fh_experience;
            parameters[13].Value = model.fh_keywd;
            parameters[14].Value = model.fh_addtime;
            parameters[15].Value = model.fh_id;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("kId", "extractdata_k"));
 }
예제 #16
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.ps_retention model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ps_retention(");
            strSql.Append("Prj_No,Prj_Name,Exp_No,MapCode,Name,SewageSystem_ID,StormSystem_ID,Type,X,Y,High,Inflow_Type,Outflow_Type,Total_Vol,B_Level,Max_Level,Min_Level,Design_Time,Ps_Num,FlowDir,Code,Address,DataSource,Sunit,Sdate,UpdateTime,Mdate,DataListID,Status,Ename,Design_Dept,Conster_Dept,Belong,Operator,Note,Exp_NoOri,FileName,Uploadtime)");
            strSql.Append(" values (");
            strSql.Append("@Prj_No,@Prj_Name,@Exp_No,@MapCode,@Name,@SewageSystem_ID,@StormSystem_ID,@Type,@X,@Y,@High,@Inflow_Type,@Outflow_Type,@Total_Vol,@B_Level,@Max_Level,@Min_Level,@Design_Time,@Ps_Num,@FlowDir,@Code,@Address,@DataSource,@Sunit,@Sdate,@UpdateTime,@Mdate,@DataListID,@Status,@Ename,@Design_Dept,@Conster_Dept,@Belong,@Operator,@Note,@Exp_NoOri,@FileName,@Uploadtime)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Prj_No",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Prj_Name",        MySqlDbType.VarChar, 100),
                new MySqlParameter("@Exp_No",          MySqlDbType.VarChar, 100),
                new MySqlParameter("@MapCode",         MySqlDbType.VarChar,  10),
                new MySqlParameter("@Name",            MySqlDbType.VarChar, 100),
                new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar,  50),
                new MySqlParameter("@StormSystem_ID",  MySqlDbType.VarChar,  50),
                new MySqlParameter("@Type",            MySqlDbType.VarChar,   4),
                new MySqlParameter("@X",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@Y",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@High",            MySqlDbType.Decimal,  10),
                new MySqlParameter("@Inflow_Type",     MySqlDbType.VarChar,  10),
                new MySqlParameter("@Outflow_Type",    MySqlDbType.VarChar,  10),
                new MySqlParameter("@Total_Vol",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@B_Level",         MySqlDbType.Decimal,  10),
                new MySqlParameter("@Max_Level",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@Min_Level",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@Design_Time",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@Ps_Num",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@FlowDir",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@Code",            MySqlDbType.VarChar,  10),
                new MySqlParameter("@Address",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@DataSource",      MySqlDbType.VarChar,  10),
                new MySqlParameter("@Sunit",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@Sdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@UpdateTime",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@Mdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@DataListID",      MySqlDbType.VarChar,  50),
                new MySqlParameter("@Status",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Ename",           MySqlDbType.VarChar, 100),
                new MySqlParameter("@Design_Dept",     MySqlDbType.VarChar, 255),
                new MySqlParameter("@Conster_Dept",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@Belong",          MySqlDbType.VarChar, 255),
                new MySqlParameter("@Operator",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Note",            MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_NoOri",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@FileName",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Uploadtime",      MySqlDbType.VarChar, 255)
            };
            parameters[0].Value  = model.Prj_No;
            parameters[1].Value  = model.Prj_Name;
            parameters[2].Value  = model.Exp_No;
            parameters[3].Value  = model.MapCode;
            parameters[4].Value  = model.Name;
            parameters[5].Value  = model.SewageSystem_ID;
            parameters[6].Value  = model.StormSystem_ID;
            parameters[7].Value  = model.Type;
            parameters[8].Value  = model.X;
            parameters[9].Value  = model.Y;
            parameters[10].Value = model.High;
            parameters[11].Value = model.Inflow_Type;
            parameters[12].Value = model.Outflow_Type;
            parameters[13].Value = model.Total_Vol;
            parameters[14].Value = model.B_Level;
            parameters[15].Value = model.Max_Level;
            parameters[16].Value = model.Min_Level;
            parameters[17].Value = model.Design_Time;
            parameters[18].Value = model.Ps_Num;
            parameters[19].Value = model.FlowDir;
            parameters[20].Value = model.Code;
            parameters[21].Value = model.Address;
            parameters[22].Value = model.DataSource;
            parameters[23].Value = model.Sunit;
            parameters[24].Value = model.Sdate;
            parameters[25].Value = model.UpdateTime;
            parameters[26].Value = model.Mdate;
            parameters[27].Value = model.DataListID;
            parameters[28].Value = model.Status;
            parameters[29].Value = model.Ename;
            parameters[30].Value = model.Design_Dept;
            parameters[31].Value = model.Conster_Dept;
            parameters[32].Value = model.Belong;
            parameters[33].Value = model.Operator;
            parameters[34].Value = model.Note;
            parameters[35].Value = model.Exp_NoOri;
            parameters[36].Value = model.FileName;
            parameters[37].Value = model.Uploadtime;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #17
0
        /// <summary>
        /// 根据字段列表,条件,排序,每页记录数,页码(从1开始),分页读取记录
        /// </summary>
        /// <param name="columslist">字段列表,如:Id,姓名,性别,年龄</param>
        /// <param name="strWhere">条件,如:年龄>12 and 性别='女'</param>
        /// <param name="filedOrder">排序,如: Id desc </param>
        /// <param name="PageSize">每页记录数,如:30</param>
        /// <param name="PageIndex">页码,如:2</param>
        /// <returns>返回组装好的json字符串</returns>
        public string GetListByPageColumns_tojson(string columslist, string strWhere, string orderby, int PageSize, int PageIndex)
        {
            string str = DbHelperMySQL.GetListByPageColumns_tojson(columslist, strWhere, orderby, PageSize, PageIndex, "tb_navigation");

            return(str);
        }
예제 #18
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("kId", "urlconfigs_k"));
 }
예제 #19
0
        /// <summary>
        /// 根据字段列表,条件,排序,每页记录数,页码(从1开始),分页读取记录
        /// </summary>
        /// <param name="columslist">字段列表,如:Id,姓名,性别,年龄</param>
        /// <param name="strWhere">条件,如:年龄>12 and 性别='女'</param>
        /// <param name="filedOrder">排序,如: Id desc </param>
        /// <param name="PageSize">每页记录数,如:30</param>
        /// <param name="PageIndex">页码,如:2</param>
        /// <returns></returns>
        public DataSet GetListByPageColumns(string columslist, string strWhere, string orderby, int PageSize, int PageIndex)
        {
            string strsql = DbHelperMySQL.GetListByPageColumns(columslist, strWhere, orderby, PageSize, PageIndex, "tb_navigation");

            return(DbHelperMySQL.Query(strsql));
        }
예제 #20
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("id", "scm_spe_supply_set"));
 }
예제 #21
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.ps_outfall model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ps_outfall(");
            strSql.Append("Prj_No,Prj_Name,Exp_No,MapCode,SewageSystem_ID,StormSystem_ID,Type,X,Y,High,Bottom_Elev,OutfallShape,OutfallType,Offset,Rotation,Code,Flap,Flap_Diameter,Flap_TopEle,Flap_BotEle,Flap_Materail,Receive,Address,PointPosition,DataSource,Visibility,Sunit,Sdate,UpdateTime,Mdate,Outfall_Type,Status,Ename,Design_Dept,Conster_Dept,Belong,Operator,Note,Exp_NoOri,FileName,Uploadtime)");
            strSql.Append(" values (");
            strSql.Append("@Prj_No,@Prj_Name,@Exp_No,@MapCode,@SewageSystem_ID,@StormSystem_ID,@Type,@X,@Y,@High,@Bottom_Elev,@OutfallShape,@OutfallType,@Offset,@Rotation,@Code,@Flap,@Flap_Diameter,@Flap_TopEle,@Flap_BotEle,@Flap_Materail,@Receive,@Address,@PointPosition,@DataSource,@Visibility,@Sunit,@Sdate,@UpdateTime,@Mdate,@Outfall_Type,@Status,@Ename,@Design_Dept,@Conster_Dept,@Belong,@Operator,@Note,@Exp_NoOri,@FileName,@Uploadtime)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Prj_No",          MySqlDbType.VarChar, 255),
                new MySqlParameter("@Prj_Name",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_No",          MySqlDbType.VarChar, 100),
                new MySqlParameter("@MapCode",         MySqlDbType.VarChar,  10),
                new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar,  50),
                new MySqlParameter("@StormSystem_ID",  MySqlDbType.VarChar,  50),
                new MySqlParameter("@Type",            MySqlDbType.VarChar,   4),
                new MySqlParameter("@X",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@Y",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@High",            MySqlDbType.Decimal,  10),
                new MySqlParameter("@Bottom_Elev",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@OutfallShape",    MySqlDbType.VarChar,  50),
                new MySqlParameter("@OutfallType",     MySqlDbType.VarChar,  10),
                new MySqlParameter("@Offset",          MySqlDbType.VarChar,  50),
                new MySqlParameter("@Rotation",        MySqlDbType.Decimal,   7),
                new MySqlParameter("@Code",            MySqlDbType.VarChar,  10),
                new MySqlParameter("@Flap",            MySqlDbType.VarChar,  10),
                new MySqlParameter("@Flap_Diameter",   MySqlDbType.Decimal,   7),
                new MySqlParameter("@Flap_TopEle",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@Flap_BotEle",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@Flap_Materail",   MySqlDbType.VarChar,  50),
                new MySqlParameter("@Receive",         MySqlDbType.VarChar,  50),
                new MySqlParameter("@Address",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@PointPosition",   MySqlDbType.Int32,    10),
                new MySqlParameter("@DataSource",      MySqlDbType.VarChar,  10),
                new MySqlParameter("@Visibility",      MySqlDbType.VarChar,   4),
                new MySqlParameter("@Sunit",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@Sdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@UpdateTime",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@Mdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@Outfall_Type",    MySqlDbType.VarChar,  10),
                new MySqlParameter("@Status",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Ename",           MySqlDbType.VarChar, 100),
                new MySqlParameter("@Design_Dept",     MySqlDbType.VarChar, 255),
                new MySqlParameter("@Conster_Dept",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@Belong",          MySqlDbType.VarChar, 255),
                new MySqlParameter("@Operator",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Note",            MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_NoOri",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@FileName",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Uploadtime",      MySqlDbType.VarChar, 255)
            };
            parameters[0].Value  = model.Prj_No;
            parameters[1].Value  = model.Prj_Name;
            parameters[2].Value  = model.Exp_No;
            parameters[3].Value  = model.MapCode;
            parameters[4].Value  = model.SewageSystem_ID;
            parameters[5].Value  = model.StormSystem_ID;
            parameters[6].Value  = model.Type;
            parameters[7].Value  = model.X;
            parameters[8].Value  = model.Y;
            parameters[9].Value  = model.High;
            parameters[10].Value = model.Bottom_Elev;
            parameters[11].Value = model.OutfallShape;
            parameters[12].Value = model.OutfallType;
            parameters[13].Value = model.Offset;
            parameters[14].Value = model.Rotation;
            parameters[15].Value = model.Code;
            parameters[16].Value = model.Flap;
            parameters[17].Value = model.Flap_Diameter;
            parameters[18].Value = model.Flap_TopEle;
            parameters[19].Value = model.Flap_BotEle;
            parameters[20].Value = model.Flap_Materail;
            parameters[21].Value = model.Receive;
            parameters[22].Value = model.Address;
            parameters[23].Value = model.PointPosition;
            parameters[24].Value = model.DataSource;
            parameters[25].Value = model.Visibility;
            parameters[26].Value = model.Sunit;
            parameters[27].Value = model.Sdate;
            parameters[28].Value = model.UpdateTime;
            parameters[29].Value = model.Mdate;
            parameters[30].Value = model.Outfall_Type;
            parameters[31].Value = model.Status;
            parameters[32].Value = model.Ename;
            parameters[33].Value = model.Design_Dept;
            parameters[34].Value = model.Conster_Dept;
            parameters[35].Value = model.Belong;
            parameters[36].Value = model.Operator;
            parameters[37].Value = model.Note;
            parameters[38].Value = model.Exp_NoOri;
            parameters[39].Value = model.FileName;
            parameters[40].Value = model.Uploadtime;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #22
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("mess_ID", "t_message"));
 }
예제 #23
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("id", "bus_dish_plan"));
 }
예제 #24
0
파일: t_admin.cs 프로젝트: sinsens/topicsys
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("id", "t_admin"));
 }
예제 #25
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("id", "userinfo"));
 }
예제 #26
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("Id", "tempvehicleinfo"));
 }
예제 #27
0
파일: user.cs 프로젝트: peakcary/net-wk
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("userId", "tuser"));
 }
예제 #28
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("id", "bus_verify_code"));
 }
예제 #29
0
 /// <summary>
 /// 得到最大ID
 /// </summary>
 public int GetMaxId()
 {
     return(DbHelperMySQL.GetMaxID("id", "sys_app"));
 }
예제 #30
0
 public UcTaskAllocation()
 {
     InitializeComponent();
     dbOperation = DBUtility.DbHelperMySQL.CreateDbHelper();
     btnSave.Tag = "新增";
 }