//appflow_10113 public JC_ProjectTenderCityCompanyInfo GetJC_ProjectTenderCityCompanyInfo(string formId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100), }; parameters[0].Value = formId; JC_ProjectTenderCityCompanyInfo model = new JC_ProjectTenderCityCompanyInfo(); DataTable dataTable = DBHelper.ExecutedProcedure("Biz.JC_ProjectTenderCityCompanyInfoByFormID_Get", parameters); if (dataTable != null && dataTable.Rows.Count > 0) { return(DataRowToModel(dataTable.Rows[0])); } else { return(null); } }
/// <summary> /// 根据流程ID获取FormId /// </summary> /// <param name="id"></param> /// <returns></returns> public static JC_ProjectTenderCityCompanyInfo GetJC_ProjectTenderCityCompanyInfoByWfId(string id) { SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.NVarChar, 100) }; parameters[0].Value = id; JC_ProjectTenderCityCompanyInfo model = new JC_ProjectTenderCityCompanyInfo(); DataTable dt = DBHelper.ExecutedProcedure("Biz.JC_ProjectTenderCityCompanyInfoByWfId_Get", parameters); if (dt != null && dt.Rows.Count > 0) { return(DataRowToModel(dt.Rows[0])); } else { return(null); } }
/// <summary> /// 更新表单数据 /// </summary> /// <param name="info"></param> public static void UpdateJC_ProjectTenderCityCompanyInfo(JC_ProjectTenderCityCompanyInfo info) { SqlParameter[] parameters = { new SqlParameter("@FormID", SqlDbType.NVarChar, 100), new SqlParameter("@SecurityLevel", SqlDbType.NVarChar, 100), new SqlParameter("@UrgenLevel", SqlDbType.NVarChar, 100), new SqlParameter("@StartDeptId", SqlDbType.NVarChar, 100), new SqlParameter("@DeptName", SqlDbType.NVarChar, 100), new SqlParameter("@UserName", SqlDbType.NVarChar, 100), new SqlParameter("@Tel", SqlDbType.NVarChar, 100), new SqlParameter("@Date", SqlDbType.NVarChar, 100), new SqlParameter("@IsAccreditByGroup", SqlDbType.NVarChar, 100), new SqlParameter("@Title", SqlDbType.NVarChar, 200), new SqlParameter("@Substance", SqlDbType.NVarChar, 2000), new SqlParameter("@RelateDepartment", SqlDbType.NVarChar, 500), new SqlParameter("@GroupRealateDept", SqlDbType.NVarChar, 500), new SqlParameter("@GroupPurchaseDept", SqlDbType.NVarChar, 500), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@FirstLevel", SqlDbType.NVarChar, 100) }; parameters[0].Value = info.FormID; parameters[1].Value = info.SecurityLevel; parameters[2].Value = info.UrgenLevel; parameters[3].Value = info.StartDeptId; parameters[4].Value = info.DeptName; parameters[5].Value = info.UserName; parameters[6].Value = info.Tel; parameters[7].Value = info.Date; parameters[8].Value = info.IsAccreditByGroup; parameters[9].Value = info.Title; parameters[10].Value = info.Substance; parameters[11].Value = info.RelateDepartment; parameters[12].Value = info.GroupRealateDept; parameters[13].Value = info.GroupPurchaseDept; parameters[14].Value = info.Remark; parameters[15].Value = info.FirstLevel; DataTable dataTable = DBHelper.ExecutedProcedure("Biz.JC_ProjectTenderCityCompanyInfo_Update", parameters); }
/// <summary> /// 得到一个实体对象[封装] /// </summary> /// <param name="dataRow"></param> /// <returns></returns> private static JC_ProjectTenderCityCompanyInfo DataRowToModel(DataRow dataRow) { JC_ProjectTenderCityCompanyInfo info = new JC_ProjectTenderCityCompanyInfo(); 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["StartDeptId"] != null) { info.StartDeptId = dataRow["StartDeptId"].ToString(); } if (dataRow["DeptName"] != null) { info.DeptName = dataRow["DeptName"].ToString(); } if (dataRow["UserName"] != null) { info.UserName = dataRow["UserName"].ToString(); } if (dataRow["Tel"] != null) { info.Tel = dataRow["Tel"].ToString(); } if (dataRow["Date"] != null) { info.Date = dataRow["Date"].ToString(); } if (dataRow["IsAccreditByGroup"] != null) { info.IsAccreditByGroup = dataRow["IsAccreditByGroup"].ToString(); } if (dataRow["Title"] != null) { info.Title = dataRow["Title"].ToString(); } if (dataRow["Substance"] != null) { info.Substance = dataRow["Substance"].ToString(); } if (dataRow["RelateDepartment"] != null) { info.RelateDepartment = dataRow["RelateDepartment"].ToString(); } if (dataRow["GroupRealateDept"] != null) { info.GroupRealateDept = dataRow["GroupRealateDept"].ToString(); } if (dataRow["GroupPurchaseDept"] != null) { info.GroupPurchaseDept = dataRow["GroupPurchaseDept"].ToString(); } if (dataRow["IsApproval"] != null) { info.IsApproval = dataRow["IsApproval"].ToString(); } if (dataRow["Remark"] != null) { info.Remark = dataRow["Remark"].ToString(); } if (dataRow["FirstLevel"] != null) { info.FirstLevel = dataRow["FirstLevel"].ToString(); } } return(info); }
/// <summary> /// 通过FormID更新表单IsApproval字段 /// </summary> /// <param name="model"></param> /// <returns></returns> public static JC_ProjectTenderCityCompanyInfo UpdateJC_ProjectTenderCityCompanyInfoByModel(JC_ProjectTenderCityCompanyInfo model) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100), new SqlParameter("@IsApproval", System.Data.SqlDbType.NVarChar, 100), }; parameters[0].Value = model.FormID; parameters[1].Value = model.IsApproval; DataTable dataTable = DBHelper.ExecutedProcedure("Biz.JC_ProjectTenderCityCompanyInfoByID_Update", parameters); return(model); }