Exemple #1
0
        /// <summary>
        /// 添加新角色信息
        /// 创建:李东峰 日期:2014-03-11
        /// </summary>
        /// <param name="rName">角色名称</param>
        /// <returns>返回是否添加成功</returns>
        public bool AddRole(string rName)
        {
            errMsg = "";
            bool      _flag = false;
            string    sql1  = "select * from T_SYS_GROUP where T_GRPID='" + RoleId + "'";
            DataTable dt    = null;

            dt = dl.RunDataTable(sql1, out errMsg);
            if (dt == null || dt.Rows.Count == 0)
            {
                string sql2 = "insert into T_SYS_GROUP (T_GRPID,T_GRPDESC) values ('" + RoleId + "','" + rName + "')";
                dl.RunNonQuery(sql2, out errMsg);
                if (errMsg == "")
                {
                    _flag = true;
                }
                else
                {
                    _flag = false;
                }
            }
            else
            {
                _flag = false;
            }
            return(_flag);
        }
Exemple #2
0
        /// <summary>
        /// 添加新班次信息
        /// 创建:李东峰 日期:2014-03-13
        /// </summary>
        /// <param name="_shiftName">班次名称</param>
        /// <param name="_startTime">班次名称</param>
        /// <param name="_endTime">班次名称</param>
        /// <returns>返回是否添加成功</returns>
        public bool AddShift(string _shiftName, string _startTime, string _endTime)
        {
            errMsg = "";
            bool      _flag = false;
            string    sql1  = "select * from T_SYS_SHIFTINFO where T_SHIFTID='" + ShfitId + "'";
            DataTable dt    = null;

            dt = dl.RunDataTable(sql1, out errMsg);
            if (dt == null || dt.Rows.Count == 0)
            {
                string sql2 = "insert into T_SYS_SHIFTINFO (T_SHIFTID,T_SHIFTNAME,D_STRATTIME,D_ENDTIME) values ('" + ShfitId + "','" + _shiftName + "','2014-01-01 " + _startTime + "','2014-01-01 " + _endTime + "')";
                dl.RunNonQuery(sql2, out errMsg);
                if (errMsg == "")
                {
                    _flag = true;
                }
                else
                {
                    _flag = false;
                }
            }
            else
            {
                _flag = false;
            }
            return(_flag);
        }
Exemple #3
0
        /// <summary>
        /// 添加新班组信息
        /// 创建:李东峰 日期:2014-03-12
        /// </summary>
        /// <param name="rName">班组名称</param>
        /// <returns>返回是否添加成功</returns>
        public bool AddClass(string _ClassName)
        {
            errMsg = "";
            bool      _flag = false;
            string    sql1  = "select * from T_SYS_CLASSINFO where T_CLASSID='" + ClassId + "'";
            DataTable dt    = null;

            dt = dl.RunDataTable(sql1, out errMsg);
            if (dt == null || dt.Rows.Count == 0)
            {
                string sql2 = "insert into T_SYS_CLASSINFO (T_CLASSID,T_CLASSNAME) values ('" + ClassId + "','" + _ClassName + "')";
                dl.RunNonQuery(sql2, out errMsg);
                if (errMsg == "")
                {
                    _flag = true;
                }
                else
                {
                    _flag = false;
                }
            }
            else
            {
                _flag = false;
            }
            return(_flag);
        }
Exemple #4
0
 /// <summary>
 /// 设置平均负荷
 /// </summary>
 /// <param name="unitId">机组编号</param>
 /// <param name="val">负荷</param>
 /// <param name="sTime">开始时间</param>
 /// <param name="eTime">结束时间</param>
 /// <returns></returns>
 public double SetPowerAvg(string unitId, double val, string sTime, string eTime)
 {
     sql   = "update T_INFO_STATISCS set T_VALUE='" + val + "' where T_UNITID='" + unitId + "' and (T_TIME between '" + sTime + "' and '" + eTime + "')";
     judge = db.RunNonQuery(sql, out errMsg);
     if (judge)
     {
         val = 1000000;
     }
     return(val);
 }
Exemple #5
0
 /// <summary>
 /// 为数据库表添加列
 /// </summary>
 /// <param name="tableName">数据库表名称</param>
 /// <param name="columns">列集合</param>
 /// <returns></returns>
 public bool CreateColumns(string tableName, string columns)
 {
     judge = true;
     for (int i = 0; i < columns.Split('*').Length; i++)
     {
         sql += "IF COL_LENGTH('" + tableName + "', '" + columns.Split('*')[i] + "') IS NULL alter table " + tableName + " add " + columns.Split('*')[i] + " char(255);";
     }
     judge = dl.RunNonQuery(sql, out errMsg);
     return(judge);
 }
Exemple #6
0
        //提交按钮对应函数
        protected void BtnSubmit_Click(object sender, EventArgs e)
        {
            int rowsCount = (this.Request.Form.Count - 3) / 8;

            StringBuilder msg = new StringBuilder();

            //确保统计时间不为空
            for (int i = 0; i < rowsCount; ++i)
            {
                if (Request.Form.Get(colNames[1] + (i == 0 ? "" : i.ToString())) == "")
                {
                    msg.AppendFormat("统计时间不能为空 \\nline:{0}", i);
                    Response.Write("<script> alert(\"" + msg.ToString() + "\")</script>");
                    return;
                }
            }

            for (int i = 0; i < rowsCount; ++i)
            {
                foreach (string col in colNames)
                {
                    hashtRow[col] = Request.Form.Get(col + (i == 0 ? "" : i.ToString()));
                }
                dl.RunNonQuery(string.Format("insert into {0} {1}", tableName, GetPartInsertSql()), out errMsg);
                //ExecuteSql(string.Format("insert into EDITPARA {0}", GetPartInsertSql()));
            }
            return;
        }
Exemple #7
0
 /// <summary>
 /// 为数据库表添加列
 /// </summary>
 /// <param name="tableName">数据库表名称</param>
 /// <param name="columns">列集合</param>
 /// <returns></returns>
 public bool CreateColumns(string tableName, string columns)
 {
     judge = true;
     //if (rlDBType == "SQL")
     //{
     for (int i = 0; i < columns.Split('*').Length; i++)
     {
         sql += "IF COL_LENGTH('" + tableName + "', '" + columns.Split('*')[i] + "') IS NULL alter table " + tableName + " add " + columns.Split('*')[i] + " char(255);";
     }
     judge = db.RunNonQuery(sql, out errMsg);
     //}
     //else if (rlDBType == "Oracle")
     //{
     //    for (int i = 0; i < columns.Split('*').Length; i++)
     //    {
     //        sql = "SELECT COUNT(*) FROM USER_TAB_COLUMNS WHERE TABLE_NAME = UPPER('" + tableName + "') AND COLUMN_NAME = '" + columns.Split('*')[i] + "'";
     //        dt = SAC.OracleHelper.OracleHelper.Query(sql).Tables[0];
     //        if (dt.Rows[0][0].ToString() == "0")
     //        {
     //            sql = "alter table " + tableName + " add(" + columns.Split('*')[i] + " varchar(255) default '')";
     //            judge = SAC.OracleHelper.OracleHelper.RunNonQuery(sql, out errMsg);
     //        }
     //    }
     //}
     return(judge);
 }
Exemple #8
0
 /// <summary>
 /// 添加报表名称
 /// </summary>
 /// <param name="name"></param>
 /// <returns></returns>
 public bool AddTable(string name, string id, string model, string tableName)
 {
     sql   = "insert into " + tableName + "(T_REPORTDESC,T_DCNAME,T_MODELID) values('" + name + "','" + id + "','" + model + "')";
     judge = dl.RunNonQuery(sql, out errMsg); sql = "";
     return(judge);
 }
Exemple #9
0
        //保存新的角色信息
        public bool SaveRole(string rId, string rName, out string errMsg)
        {
            errMsg = "";
            bool      flag = false;
            string    sql1 = "select * from Administrator.T_SYS_GROUP where T_GRPID='" + rId + "'";
            DataTable dt   = null;

            dt = dl.RunDataTable(sql1, out errMsg);
            if (dt == null || dt.Rows.Count == 0)
            {
                string sql2 = "insert into Administrator.T_SYS_GROUP (T_GRPID,T_GRPDESC) values ('" + rId + "','" + rName + "')";
                dl.RunNonQuery(sql2, out errMsg);
                if (errMsg == "")
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            else
            {
                return(false);
            }
        }
Exemple #10
0
        /// <summary>
        /// 添加人员
        /// 创建:李东峰 日期:2014-03-10
        /// </summary>
        /// <param name="_userName">用户真实姓名</param>
        /// <param name="_passWord">用户密码</param>
        /// <param name="_attachMent">用户照片</param>
        /// <param name="_classId">用户班组</param>
        /// <param name="_posId">用户岗位</param>
        /// <param name="_posId">用户所属角色ID</param>
        /// <returns>返回是否添加成功</returns>
        public bool AddMember(string _userName, string _passWord, byte[] _attachMent, string _classId, string _posId, string _grpId)
        {
            string rlDBType = dl.init();
            string _errMsg;
            string sql1   = "";
            string sql2   = "";
            bool   result = false;

            if (rlDBType == "SQL")
            {
                if (_attachMent != null && _attachMent.Length > 0)
                {
                    sql1 = "insert into T_SYS_MEMBERINFO(T_USERID,T_USERNAME,T_PASSWD,B_ATTACHMENT,T_CLASSID,T_POSID) values(@T_USERID,@T_USERNAME,@T_PASSWD,@B_ATTACHMENT,@T_CLASSID,@T_POSID);";
                }
                else
                {
                    sql1 = "insert into T_SYS_MEMBERINFO(T_USERID,T_USERNAME,T_PASSWD,T_CLASSID,T_POSID) values(@T_USERID,@T_USERNAME,@T_PASSWD,@T_CLASSID,@T_POSID);";
                }
                sql2 = "insert into T_SYS_MEMBERGRP(T_USERID,T_GRPID) values('" + UserId + "','" + _grpId + "')";
                try
                {
                    SqlConnection sqlconn = SAC.DBOperations.DBsql.GetConnection();
                    SqlCommand    sqlcmd  = new SqlCommand(sql1, sqlconn);
                    if (_attachMent != null && _attachMent.Length > 0)
                    {
                        sqlcmd.Parameters.Add("@T_USERID", UserId);
                        sqlcmd.Parameters.Add("@T_USERNAME", _userName);
                        sqlcmd.Parameters.Add("@T_PASSWD", _passWord);
                        sqlcmd.Parameters.Add("@B_ATTACHMENT", _attachMent);
                        sqlcmd.Parameters.Add("@T_PASSWD", _classId);
                        sqlcmd.Parameters.Add("@T_POSID", _posId);
                    }
                    else
                    {
                        sqlcmd.Parameters.Add("@T_USERID", UserId);
                        sqlcmd.Parameters.Add("@T_USERNAME", _userName);
                        sqlcmd.Parameters.Add("@T_PASSWD", _passWord);
                        sqlcmd.Parameters.Add("@T_PASSWD", _classId);
                        sqlcmd.Parameters.Add("@T_POSID", _posId);
                    }
                    if (sqlcmd.ExecuteNonQuery() > 0)
                    {
                        result = true;
                    }
                    sqlconn.Close();
                    dl.RunNonQuery(sql2, out _errMsg);
                }
                catch (Exception ex)
                {
                    LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间:" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息:" + ex.Message);
                    result = false;
                }
            }
            else if (rlDBType == "DB2")
            {
                if (_attachMent != null && _attachMent.Length > 0)
                {
                    sql1 = "insert into T_SYS_MEMBERINFO(T_USERID,T_USERNAME,T_PASSWD,B_ATTACHMENT,T_CLASSIS,T_POSID) values(?,?,?,?,?,?);";
                }
                else
                {
                    sql1 = "insert into T_SYS_MEMBERINFO(T_USERID,T_USERNAME,T_PASSWD,T_CLASSIS,T_POSID) values(?,?,?,?,?);";
                }
                sql2 = "insert into T_SYS_MEMBERGRP(T_USERID,T_GRPID) values('" + UserId + "','" + _grpId + "')";
                try
                {
                    OleDbConnection con = new OleDbConnection(SAC.DBOperations.DBdb2.SetConString());
                    con.Open();
                    OleDbCommand oledbcom = new OleDbCommand(sql1, con);
                    if (_attachMent != null && _attachMent.Length > 0)
                    {
                        oledbcom.Parameters.Add("?", UserId);
                        oledbcom.Parameters.Add("?", _userName);
                        oledbcom.Parameters.Add("?", _passWord);
                        oledbcom.Parameters.Add("?", _attachMent);
                        oledbcom.Parameters.Add("?", _classId);
                        oledbcom.Parameters.Add("?", _posId);
                    }
                    else
                    {
                        oledbcom.Parameters.Add("?", UserId);
                        oledbcom.Parameters.Add("?", _userName);
                        oledbcom.Parameters.Add("?", _passWord);
                        oledbcom.Parameters.Add("?", _classId);
                        oledbcom.Parameters.Add("?", _posId);
                    }
                    if (oledbcom.ExecuteNonQuery() > 0)
                    {
                        result = true;
                    }
                    con.Close();
                    dl.RunNonQuery(sql2, out _errMsg);
                }
                catch (Exception ex)
                {
                    LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间:" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息:" + ex.Message);
                    result = false;
                }
            }
            else if (rlDBType == "ORACLE")
            {
                if (_attachMent != null && _attachMent.Length > 0)
                {
                    sql1 = "insert into T_SYS_MEMBERINFO(T_USERID,T_USERNAME,T_PASSWD,B_ATTACHMENT,T_CLASSIS,T_POSID) values(:blobtodb,:blobtodb,:blobtodb,:blobtodb,:blobtodb,:blobtodb);";
                }
                else
                {
                    sql1 = "insert into T_SYS_MEMBERINFO(T_USERID,T_USERNAME,T_PASSWD,T_CLASSIS,T_POSID) values(:blobtodb,:blobtodb,:blobtodb,:blobtodb,:blobtodb);";
                }
                sql2 = "insert into T_SYS_MEMBERGRP(T_USERID,T_GRPID) values('" + UserId + "','" + _grpId + "')";
                try
                {
                    OracleConnection con = new OracleConnection(SAC.DBOperations.OracleHelper.retStr());
                    con.Open();
                    OracleCommand oledbcom = new OracleCommand(sql1, con);
                    if (_attachMent != null && _attachMent.Length > 0)
                    {
                        oledbcom.Parameters.Add("blobtodb", UserId);
                        oledbcom.Parameters.Add("blobtodb", _userName);
                        oledbcom.Parameters.Add("blobtodb", _passWord);
                        oledbcom.Parameters.Add("blobtodb", _attachMent);
                        oledbcom.Parameters.Add("blobtodb", _classId);
                        oledbcom.Parameters.Add("blobtodb", _posId);
                    }
                    else
                    {
                        oledbcom.Parameters.Add("blobtodb", UserId);
                        oledbcom.Parameters.Add("blobtodb", _userName);
                        oledbcom.Parameters.Add("blobtodb", _passWord);
                        oledbcom.Parameters.Add("blobtodb", _classId);
                        oledbcom.Parameters.Add("blobtodb", _posId);
                    }
                    if (oledbcom.ExecuteNonQuery() > 0)
                    {
                        result = true;
                    }
                    con.Close();
                    dl.RunNonQuery(sql2, out _errMsg);
                }
                catch (Exception ex)
                {
                    LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间:" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息:" + ex.Message);
                    result = false;
                }
            }
            return(result);
        }