//app3007 public ContractAuditOfGroupInfo GetContractAuditOfGroupInfo(string formId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100), }; parameters[0].Value = formId; ContractAuditOfGroupInfo model = new ContractAuditOfGroupInfo(); DataTable dataTable = DBHelper.ExecutedProcedure("Biz.OA_ContractAuditOfGroupInfoByFormID_Get", parameters); if (dataTable != null && dataTable.Rows.Count > 0) { return(DataRowToModel(dataTable.Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个实体对象【封装】 /// </summary> /// <param name="dataRow"></param> /// <returns></returns> private ContractAuditOfGroupInfo DataRowToModel(DataRow dataRow) { ContractAuditOfGroupInfo info = new ContractAuditOfGroupInfo(); if (dataRow != null) { if (dataRow["FormID"] != null) { info.FormID = dataRow["FormID"].ToString(); } if (dataRow["SecurityLevel"] != null) { info.SecurityLevel = dataRow["SecurityLevel"].ToString(); } if (dataRow["UrgenLevel"] != null) { info.UrgenLevel = dataRow["UrgenLevel"].ToString(); } if (dataRow["DeptName"] != null) { info.DeptName = dataRow["DeptName"].ToString(); } if (dataRow["DeptCode"] != null) { info.DeptCode = dataRow["DeptCode"].ToString(); } if (dataRow["UserName"] != null) { info.UserName = dataRow["UserName"].ToString(); } if (dataRow["Mobile"] != null) { info.Mobile = dataRow["Mobile"].ToString(); } if (dataRow["DateTime"] != null) { info.DateTime = dataRow["DateTime"].ToString(); } if (dataRow["ContractType1"] != null) { info.ContractType1 = dataRow["ContractType1"].ToString(); } if (dataRow["ContractTypeName1"] != null) { info.ContractTypeName1 = dataRow["ContractTypeName1"].ToString(); } if (dataRow["ContractType2"] != null) { info.ContractType2 = dataRow["ContractType2"].ToString(); } if (dataRow["ContractTypeName2"] != null) { info.ContractTypeName2 = dataRow["ContractTypeName2"].ToString(); } if (dataRow["ContractType3"] != null) { info.ContractType3 = dataRow["ContractType3"].ToString(); } if (dataRow["ContractTypeName3"] != null) { info.ContractTypeName3 = dataRow["ContractTypeName3"].ToString(); } if (dataRow["ContractSum"] != null) { info.ContractSum = dataRow["ContractSum"].ToString(); } if (dataRow["IsSupplementProtocol"] != null) { info.IsSupplementProtocol = dataRow["IsSupplementProtocol"].ToString(); } if (dataRow["IsSupplementProtocolText"] != null) { info.IsSupplementProtocolText = dataRow["IsSupplementProtocolText"].ToString(); } if (dataRow["IsFormatContract"] != null) { info.IsFormatContract = dataRow["IsFormatContract"].ToString(); } if (dataRow["IsNormText"] != null) { info.IsNormText = dataRow["IsNormText"].ToString(); } if (dataRow["IsBidding"] != null) { info.IsBidding = dataRow["IsBidding"].ToString(); } if (dataRow["IsEstateProject"] != null) { info.IsEstateProject = dataRow["IsEstateProject"].ToString(); } if (dataRow["EstateProjectName"] != null) { info.EstateProjectName = dataRow["EstateProjectName"].ToString(); } if (dataRow["EstateProjectNum"] != null) { info.EstateProjectNum = dataRow["EstateProjectNum"].ToString(); } if (dataRow["EstateProjectNameText"] != null) { info.EstateProjectNameText = dataRow["EstateProjectNameText"].ToString(); } if (dataRow["EstateProjectNumText"] != null) { info.EstateProjectNumText = dataRow["EstateProjectNumText"].ToString(); } if (dataRow["ContractSubject"] != null) { info.ContractSubject = dataRow["ContractSubject"].ToString(); } if (dataRow["ContractSubjectName"] != null) { info.ContractSubjectName = dataRow["ContractSubjectName"].ToString(); } if (dataRow["ContractSubjectName2"] != null) { info.ContractSubjectName2 = dataRow["ContractSubjectName2"].ToString(); } if (dataRow["ContractSubjectName3"] != null) { info.ContractSubjectName3 = dataRow["ContractSubjectName3"].ToString(); } if (dataRow["ContractSubjectName4"] != null) { info.ContractSubjectName4 = dataRow["ContractSubjectName4"].ToString(); } if (dataRow["ContractTitle"] != null) { info.ContractTitle = dataRow["ContractTitle"].ToString(); } if (dataRow["ContractContent"] != null) { info.ContractContent = dataRow["ContractContent"].ToString(); } if (dataRow["LeadersSelected"] != null) { info.LeadersSelected = dataRow["LeadersSelected"].ToString(); } if (dataRow["IsReport"] != null) { info.IsReport = dataRow["IsReport"].ToString(); } if (dataRow["IsApproval"] != null) { info.IsApproval = dataRow["IsApproval"].ToString(); } if (dataRow["RelatedFormID"] != null) { info.RelatedFormID = dataRow["RelatedFormID"].ToString(); } } return(info); }
/// <summary> /// 更新表 /// </summary> /// <param name="obj"></param> public void Update(ContractAuditOfGroupInfo model) { SqlParameter[] parameters = { new SqlParameter("@FormID", SqlDbType.NVarChar, 100), new SqlParameter("@SecurityLevel", SqlDbType.NVarChar, 100), new SqlParameter("@UrgenLevel", SqlDbType.NVarChar, 100), new SqlParameter("@DeptName", SqlDbType.NVarChar, 200), new SqlParameter("@DeptCode", SqlDbType.NVarChar, 100), new SqlParameter("@UserName", SqlDbType.NVarChar, 100), new SqlParameter("@Mobile", SqlDbType.NVarChar, 100), new SqlParameter("@DateTime", SqlDbType.NVarChar, 100), new SqlParameter("@ContractSum", SqlDbType.NVarChar, 100), new SqlParameter("@IsSupplementProtocol", SqlDbType.NVarChar, 100), new SqlParameter("@IsFormatContract", SqlDbType.NVarChar, 100), new SqlParameter("@IsNormText", SqlDbType.NVarChar, 100), new SqlParameter("@IsBidding", SqlDbType.NVarChar, 100), new SqlParameter("@IsEstateProject", SqlDbType.NVarChar, 100), new SqlParameter("@EstateProjectName", SqlDbType.NVarChar, 300), new SqlParameter("@EstateProjectNum", SqlDbType.NVarChar, 100), new SqlParameter("@ContractTitle", SqlDbType.NVarChar, 500), new SqlParameter("@ContractContent", SqlDbType.NVarChar, 4000), new SqlParameter("@LeadersSelected", SqlDbType.NVarChar, 4000), new SqlParameter("@IsReport", SqlDbType.NVarChar, 100), new SqlParameter("@ContractType1", SqlDbType.NVarChar, 100), new SqlParameter("@ContractTypeName1", SqlDbType.NVarChar, 200), new SqlParameter("@ContractType2", SqlDbType.NVarChar, 200), new SqlParameter("@ContractTypeName2", SqlDbType.NVarChar, 200), new SqlParameter("@ContractType3", SqlDbType.NVarChar, 200), new SqlParameter("@ContractTypeName3", SqlDbType.NVarChar, 200), new SqlParameter("@ContractSubject", SqlDbType.NVarChar, 500), new SqlParameter("@ContractSubjectName", SqlDbType.NVarChar, 200), new SqlParameter("@ContractSubjectName2", SqlDbType.NVarChar, 200), new SqlParameter("@ContractSubjectName3", SqlDbType.NVarChar, 200), new SqlParameter("@ContractSubjectName4", SqlDbType.NVarChar, 200), new SqlParameter("@IsSupplementProtocolText", SqlDbType.NVarChar, 50), new SqlParameter("@RelatedFormID", SqlDbType.NVarChar, 200), new SqlParameter("@EstateProjectNameText", SqlDbType.NVarChar, 300), new SqlParameter("@EstateProjectNumText", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.FormID; parameters[1].Value = model.SecurityLevel; parameters[2].Value = model.UrgenLevel; parameters[3].Value = model.DeptName; parameters[4].Value = model.DeptCode; parameters[5].Value = model.UserName; parameters[6].Value = model.Mobile; parameters[7].Value = model.DateTime; parameters[8].Value = model.ContractSum; parameters[9].Value = model.IsSupplementProtocol; parameters[10].Value = model.IsFormatContract; parameters[11].Value = model.IsNormText; parameters[12].Value = model.IsBidding; parameters[13].Value = model.IsEstateProject; parameters[14].Value = model.EstateProjectName; parameters[15].Value = model.EstateProjectNum; parameters[16].Value = model.ContractTitle; parameters[17].Value = model.ContractContent; parameters[18].Value = model.LeadersSelected; parameters[19].Value = model.IsReport; parameters[20].Value = model.ContractType1; parameters[21].Value = model.ContractTypeName1; parameters[22].Value = model.ContractType2; parameters[23].Value = model.ContractTypeName2; parameters[24].Value = model.ContractType3; parameters[25].Value = model.ContractTypeName3; parameters[26].Value = model.ContractSubject; parameters[27].Value = model.ContractSubjectName; parameters[28].Value = model.ContractSubjectName2; parameters[29].Value = model.ContractSubjectName3; parameters[30].Value = model.ContractSubjectName4; parameters[31].Value = model.IsSupplementProtocolText; parameters[32].Value = model.RelatedFormID; parameters[33].Value = model.EstateProjectNameText; parameters[34].Value = model.EstateProjectNumText; DataTable dataTable = DBHelper.ExecutedProcedure("Biz.OA_ContractAuditOfGroupInfo_Update", parameters); }