Beispiel #1
0
        public SealOfPKURGIInfo Get(string FormID)
        {
            SqlParameter[] parameters = new SqlParameter[] {
                new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100)
            };
            parameters[0].Value = FormID;
            DataTable        dt   = DBHelper.ExecutedProcedure("Biz.OA_SealOfPKURGI_Get", parameters);
            SealOfPKURGIInfo Info = new SealOfPKURGIInfo();

            if (dt != null && dt.Rows.Count > 0)
            {
                Info.FormID          = Assign(dt.Rows[0]["FormID"]);
                Info.SecurityLevel   = Assign(dt.Rows[0]["SecurityLevel"]);
                Info.UrgenLevel      = Assign(dt.Rows[0]["UrgenLevel"]);
                Info.DeptName        = Assign(dt.Rows[0]["DeptName"]);
                Info.DeptCode        = Assign(dt.Rows[0]["DeptCode"]);
                Info.UserName        = Assign(dt.Rows[0]["UserName"]);
                Info.Mobile          = Assign(dt.Rows[0]["Mobile"]);
                Info.DateTime        = Assign(dt.Rows[0]["DateTime"]);
                Info.Title           = Assign(dt.Rows[0]["Title"]);
                Info.Content         = Assign(dt.Rows[0]["Content"]);
                Info.LeadersSelected = Assign(dt.Rows[0]["LeadersSelected"]);
                Info.IsApproval      = Assign(dt.Rows[0]["IsApproval"]);
                return(Info);
            }

            return(null);
        }
Beispiel #2
0
        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Update(SealOfPKURGIInfo model)
        {
            string sql = string.Format("Update Biz.OA_SealOfPKURGI set SecurityLevel='{0}',UrgenLevel = '{1}',DeptName = '{2}',DeptCode='{3}'," +
                                       "UserName='******',Mobile='{5}',DateTime='{6}',Title='{7}',Content='{8}',LeadersSelected='{9}',IsApproval = '{10}' where FormID = '{11}'",
                                       model.SecurityLevel, model.UrgenLevel, model.DeptName, model.DeptCode, model.UserName, model.Mobile, model.DateTime,
                                       model.Title, model.Content, model.LeadersSelected, model.IsApproval, model.FormID);

            return(DBHelper.ExecuteNonQuery(sql));
        }
Beispiel #3
0
        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Insert(SealOfPKURGIInfo model)
        {
            string sql = string.Format("INSERT INTO Biz.OA_SealOfPKURGI (FormID,SecurityLevel,UrgenLevel,DeptName ,DeptCode,UserName," +
                                       "Mobile, DateTime,Title,Content,LeadersSelected, IsApproval) VALUES" +
                                       "('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", model.FormID,
                                       model.SecurityLevel, model.UrgenLevel, model.DeptName, model.DeptCode, model.UserName, model.Mobile,
                                       model.DateTime, model.Title, model.Content, model.LeadersSelected, model.IsApproval);

            return(DBHelper.ExecuteNonQuery(sql));
        }