//获得表单数据
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;
}
