Пример #1
0
        public bool UpdatePassword(string username, string password)
        {
            string sql = "update sysuser set password=@password where username=@username and status=1";

            SqlParameter[] param = new SqlParameter[] {
                new SqlParameter("@username", username),
                new SqlParameter("@password", password)
            };
            return(sqlconn.ExecuteSql(sql, param) > 0 ? true : false);
        }
Пример #2
0
        public bool InsertRoleInfo(string rolename, string remark, string createby)
        {
            string sql = "insert into roleinfo (rolename,remark,createby,createtime) values(@rolename,@remark,@createby,getdate())";

            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@rolename", rolename),
                new SqlParameter("@remark", remark),
                new SqlParameter("@createby", createby)
            };
            return(sqlconn.ExecuteSql(sql, param) > 0 ? true : false);
        }
Пример #3
0
        public bool InsertDeptInfo(string deptname, string remark, string createby)
        {
            string sql = "insert into department (deptname,remark,createby,createtime) values(@deptname,@remark,@createby,getdate())";

            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@deptname", deptname),
                new SqlParameter("@remark", remark),
                new SqlParameter("@createby", createby)
            };
            return(sqlconn.ExecuteSql(sql, param) > 0?true:false);
        }
Пример #4
0
        public bool InsertMenuInfo(string menuname, string path, int parentid, int sort, string createby, string ImagePath)
        {
            string sql = "insert into menuinfo (menuname,path,parentid,sort,createby,createtime,image_path) values(@menuname,@path,@parentid,@sort,@createby,getdate(),@image_path)";

            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@menuname", menuname),
                new SqlParameter("@path", path),
                new SqlParameter("@parentid", parentid),
                new SqlParameter("@sort", sort),
                new SqlParameter("@createby", createby),
                new SqlParameter("@image_path", ImagePath)
            };
            return(sqlconn.ExecuteSql(sql, param) > 0 ? true : false);
        }
Пример #5
0
        public bool CompletedSendEmail(string queueNo)
        {
            string sql = @"update email_queue set active=1,compelete_time=GETDATE()
                            where active = 0 and queue_no = '" + queueNo + "'";

            return(test.ExecuteSql(sql) > 0?true:false);
        }
Пример #6
0
        public bool InsertCommunicationLog(CommunicationLogs communicationLogs)
        {
            string sql = "insert into CommunicationLogs( rec_message, rec_time,res_message) values( @rec_message, @rec_time, @res_message)";

            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@rec_message", communicationLogs.rec_message),
                new SqlParameter("@rec_time", communicationLogs.rec_time),
                new SqlParameter("@res_message", communicationLogs.res_message)
            };
            return(sqlconn.ExecuteSql(sql, param) > 0 ? true : false);
        }
Пример #7
0
        /// <summary>
        /// 存储实时信息
        /// </summary>
        /// <param name="productlog"></param>
        /// <returns></returns>
        public bool InsertProductlog(Productlog productlog)
        {
            string sql = "insert into Productlog( key_process, equipment, productno, result, contents, createtime) values( @key_process,@equipment,@productno,@result,@contents,@createtime)";

            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@key_process", productlog.key_process),
                new SqlParameter("@equipment", productlog.equipment),
                new SqlParameter("@productno", productlog.productno),
                new SqlParameter("@result", productlog.result),
                new SqlParameter("@contents", productlog.contents),
                new SqlParameter("@createtime", productlog.createtime),
            };
            return(sqlconn.ExecuteSql(sql, param) > 0 ? true : false);
        }