//获得表单数据 public FormStoreDTO GetFormStore(decimal?store_id) { FormStoreDTO result = null; using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("i_STORE_ID", store_id); List <FormStoreDTO> list = null; list = dbHelper.ExecuteListProc <FormStoreDTO>("pkg_form_store.sp_form_store_get", dic); if (list.Count > 0) { result = list[0]; } } catch (Exception ex) { throw; } } return(result); }
//获得object对象 public ObjectDTO GetObjectById(decimal objectId) { ObjectDTO result = null; using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("i_object_id", objectId); List <ObjectDTO> list = null; list = dbHelper.ExecuteListProc <ObjectDTO>("PKG_OBJECT.sp_object_get", dic); if (list.Count > 0) { result = list[0]; } } catch (Exception ex) { throw; } } return(result); }
/// <summary> /// 创建数据访问类 /// </summary> /// <returns>数据访问类</returns> private BaseDB CreateDBHelper(string dbName) { BaseDB baseDB = null; switch (dbName) { case "redas": baseDB = new RedasDBHelper(); break; case "ompd": baseDB = new OmpdDBHelper(); break; } return baseDB; }
/// <summary> /// 保存报告字段信息后,需要更新估价对象的报告实例ID /// </summary> /// <param name="info"></param> /// <returns></returns> private void UpdateProjectInstanceDocumentID(decimal projectId, decimal instance_Document_ID, EntrustItem t) { BaseResult br = new BaseResult() { Succeeded = true, Errors = new List <string>() }; using (BaseDB dbHelper = new RedasDBHelper()) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("i_project_id", projectId); dic.Add("i_instanceDocument_id", instance_Document_ID); dic.Add("i_type", (int)t); dbHelper.ExecuteNonQueryProc("pkg_project.sp_InstanceDocumentID_update", dic); } }
/// <summary> /// 更改估价对象表的ReportFileID /// </summary> /// <param name="objectId"></param> /// <param name="report_file_id"></param> public void UpdateReportFileID(decimal objectId, decimal report_file_id, EntrustItem t) { BaseResult br = new BaseResult() { Succeeded = true, Errors = new List <string>() }; using (BaseDB dbHelper = new RedasDBHelper()) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("i_object_id", objectId); dic.Add("i_report_file_id", report_file_id); dic.Add("i_type", (int)t); dbHelper.ExecuteNonQueryProc("PKG_OBJECT.sp_ReportFileID_update", dic); } }
private string GetBasicData(decimal objectId, string fieldId, string conCode, string buildingCode, string houseCode, string unitCode, string objectType) { var formView = new FormLogic().GetFormDataByObjectId(Convert.ToInt32(objectId), 1); List <Redas.Entities.Ompd.FormLabelDTO> lstLabel = formView.LABLELIST.ToList(); string value = ""; using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("i_object_id", objectId); dic.Add("i_unit_code", unitCode); dic.Add("i_house_code", houseCode); dic.Add("i_building_code", buildingCode); dic.Add("i_construction_code", conCode); dic.Add("i_new_purpose_id", objectType); dic.Add("i_field_id", fieldId); value = dbHelper.ExecuteScalarProc("pkg_object.sp_redas_basicData_get", dic).ToString(); } catch { } } return(value); //StringBuilder strSql = new StringBuilder(); //strSql.Append("select f.fsq_field as FIELDNAME,t.fsq_table as TABLENAME from t_redas_db_field f "); //strSql.Append(" inner join t_redas_db_table t on f.db_table_id=t.db_table_id "); //strSql.Append(" where f.fsq_field_id=:i_fieldId and t.is_virutal=0"); //Dictionary<string, object> parameters = new Dictionary<string, object>(); //parameters["i_fieldId"] = fieldId; //var obj = new RedasDBHelper().ExecuteList<STRINGMODEL>(strSql.ToString(), parameters); //if (obj.Count > 0) //{ // strSql = new StringBuilder(); // strSql.Append("select " + obj[0].FIELDNAME + " from " + obj[0].TABLENAME + ""); //} //else //{ //} }
public Dictionary<string, string> GetTemplateParms(string sql) { Dictionary<string, string> dic = new Dictionary<string, string>(); using (BaseDB redasHelper = new RedasDBHelper()) { DataTable tmpData = redasHelper.ExecuteDataTable(sql, null); if (tmpData != null && tmpData.Rows.Count > 0) { foreach (DataColumn col in tmpData.Columns) { dic.Add(col.ColumnName, tmpData.Rows[0][col.ColumnName].ToString()); } } tmpData.Dispose(); } return dic; }
//获得补齐资料的值 private string GetAddInfoItemValue(decimal objectId, string tableId, string fieldId) { using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("i_object_id", objectId); dic.Add("i_table_id", tableId); dic.Add("i_field_id", fieldId); var obj = dbHelper.ExecuteScalarProc("pkg_object.sp_AddInfoItemValue_get", dic); return(obj == null ? string.Empty : obj.ToString()); } catch { } } return(string.Empty); }
/// <summary> /// 根据项目ID获得估价对象集合 /// </summary> /// <param name="customerId"></param> /// <returns></returns> public IList <ObjectAndHouseModel> GetObjectByProjectId(int projectId) { IList <ObjectAndHouseModel> result = null; using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("i_project_id", projectId); result = dbHelper.ExecuteListProc <ObjectAndHouseModel>("PKG_OBJECT.sp_objectByProjectId_get", dic); } catch { result = new List <ObjectAndHouseModel>(); } } return(result); }
public FormViewModel GetFormDataByObjectId(int ObjectId, int FormType) { FormViewModel formInstance = new FormViewModel(); FormLabelDTO label = new FormLabelDTO(); Dictionary <string, object> dsDic = new Dictionary <string, object>(); dsDic.Add("i_object_id", ObjectId); dsDic.Add("i_form_type", FormType); using (BaseDB db = new RedasDBHelper()) { IList <FormViewModel> InstanceList = db.ExecuteListProc <FormViewModel>("pkg_forminstance.sp_get_formDataByObj", dsDic); if (InstanceList != null && InstanceList.Count > 0) { formInstance = InstanceList[0]; //formInstance.LABLELIST = JsonTools.JsonToObject2<List<FormLabelDTO>>(formInstance.CONTENTS).OrderBy(l => l.SORT).ToList(); formInstance.LABLELIST = JsonTools.JsonToObject2 <DFormViewModel>(formInstance.CONTENTS).FormLabels .Where(l => l.IsSelected == true) .OrderBy(l => l.SORT).ToList(); List <LabelDataDTO> lstData = new List <LabelDataDTO>(); if (!string.IsNullOrEmpty(formInstance.FORMDATA)) { lstData = JsonTools.JsonToObject2 <List <LabelDataDTO> >(formInstance.FORMDATA); } foreach (LabelDataDTO c in lstData) { decimal id = 0; decimal.TryParse(c.NAME, out id); if (id > 0) { label = formInstance.LABLELIST.SingleOrDefault(l => l.FORM_LABEL_ID == Convert.ToDecimal(c.NAME)); if (label == null) { continue; } label.CONTENT = c.VALUE; //label.CONTENT =label.FIELD_TYPE == "DATE"?Convert.ToDateTime(c.VALUE): c.VALUE; } } } } return(formInstance); }
// /// <summary> /// 获得询价信息中的多个表单的信息 /// </summary> /// <param name="objectId"></param> /// <param name="type">1:询价 2:查勘</param> /// <returns></returns> public JArray GetDynamicFormData(decimal objectId, int type) { JArray jArray = new JArray(); using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("i_object_id", objectId); dic.Add("i_type", type); var obj = dbHelper.ExecuteScalarProc("pkg_object.sp_redas_formData_get", dic); if (obj != null) { jArray = JArray.Parse(obj.ToString()); } } catch { throw; } } return jArray; }
private string GetBasicData(decimal objectId, string fieldId, string conCode, string buildingCode, string houseCode, string unitCode, string objectType) { string value = ""; using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("i_object_id", objectId); dic.Add("i_unit_code", unitCode); dic.Add("i_house_code", houseCode); dic.Add("i_building_code", buildingCode); dic.Add("i_construction_code", conCode); dic.Add("i_new_purpose_id", objectType); dic.Add("i_field_id", fieldId); value = dbHelper.ExecuteScalarProc("pkg_object.sp_redas_basicData_get", dic).ToString(); } catch { } } return value; }