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

            if (dt != null && dt.Rows.Count > 0)
            {
                Info.FormID                  = Assign(dt.Rows[0]["FormID"]);
                Info.chkCadresOrRemoval      = Assign(dt.Rows[0]["chkCadresOrRemoval"]);
                Info.CadresName              = Assign(dt.Rows[0]["CadresName"]);
                Info.LocationCompanyDeptJob  = Assign(dt.Rows[0]["LocationCompanyDeptJob"]);
                Info.CadresCompanyDeptJob    = Assign(dt.Rows[0]["CadresCompanyDeptJob"]);
                Info.CadresContent           = Assign(dt.Rows[0]["CadresContent"]);
                Info.RemovalName             = Assign(dt.Rows[0]["RemovalName"]);
                Info.LocationCompanyDeptJobR = Assign(dt.Rows[0]["LocationCompanyDeptJobR"]);
                Info.RemovalCompanyDeptjob   = Assign(dt.Rows[0]["RemovalCompanyDeptjob"]);
                Info.RemovalContent          = Assign(dt.Rows[0]["RemovalContent"]);
                Info.LeadersSelected         = Assign(dt.Rows[0]["LeadersSelected"]);
                Info.IsApproval              = Assign(dt.Rows[0]["IsApproval"]);
                Info.IsGroup                 = Assign(dt.Rows[0]["IsGroup"]);
                return(Info);
            }

            return(null);
        }
Beispiel #2
0
        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Update(CadresOrRemovalInfo model)
        {
            string sql = string.Format("Update Biz.HR_CadresOrRemoval set chkCadresOrRemoval='{0}',CadresName = '{1}',LocationCompanyDeptJob = '{2}',CadresCompanyDeptJob='{3}'," +
                                       "CadresContent='{4}',RemovalName='{5}',LocationCompanyDeptJobR='{6}',RemovalCompanyDeptjob='{7}',RemovalContent='{8}',LeadersSelected='{9}',IsApproval = '{10}',IsGroup='{11}' where FormID = '{11}'",
                                       model.chkCadresOrRemoval, model.CadresName, model.LocationCompanyDeptJob, model.CadresCompanyDeptJob, model.CadresContent, model.RemovalName, model.LocationCompanyDeptJobR,
                                       model.RemovalCompanyDeptjob, model.RemovalContent, model.LeadersSelected, model.IsApproval, model.IsGroup, model.FormID);

            return(DBHelper.ExecuteNonQuery(sql));
        }
Beispiel #3
0
        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Insert(CadresOrRemovalInfo model)
        {
            string sql = string.Format("INSERT INTO Biz.HR_CadresOrRemoval (FormID,chkCadresOrRemoval,CadresName,LocationCompanyDeptJob ,CadresCompanyDeptJob,CadresContent," +
                                       "RemovalName, LocationCompanyDeptJobR,RemovalCompanyDeptjob,RemovalContent,LeadersSelected, IsApproval,IsGroup) VALUES" +
                                       "('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')", model.FormID,
                                       model.chkCadresOrRemoval, model.CadresName, model.LocationCompanyDeptJob, model.CadresCompanyDeptJob, model.CadresContent, model.RemovalName,
                                       model.LocationCompanyDeptJobR, model.RemovalCompanyDeptjob, model.RemovalContent, model.LeadersSelected, model.IsApproval, model.IsGroup);

            return(DBHelper.ExecuteNonQuery(sql));
        }