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); }
/// <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)); }
/// <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)); }