public BaseResult UpdateInstance_Structure(T_INSTANCE_DOCUMENT info)
{
BaseResult br = new BaseResult()
{
Succeeded = true, Errors = new List <string>()
};
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary <string, object> dic = BaseDB.EntityToDictionary(info);
if (info.INSTANCE_DOCUMENT_ID > 0)
{
dbHelper.ExecuteNonQueryProc("pkg_redas_instance_document.sp_instance_modifyStructure", dic);
br.ResultId = info.INSTANCE_DOCUMENT_ID;
}
}
catch (Exception ex)
{
br.Succeeded = false;
br.Errors.Add("修改不成功");
throw;
}
return(br);
}
}
/// <summary>
/// 保存标签信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public BaseResult SaveLabel(DataLabelModel model)
{
BaseResult result = new BaseResult() { Succeeded = true };
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = BaseDB.EntityToDictionary(model);
if (model.DATA_LABEL_ID == 0)
{
model.CREATED_TIME = DateTime.Now;
dbHelper.ExecuteNonQueryProc("PKG_UCS_DATA_LABEL.sp_data_label_add", dic);
}
else
{
model.MODIFIED_TIME = DateTime.Now;
dbHelper.ExecuteNonQueryProc("PKG_UCS_DATA_LABEL.sp_data_label_modify", dic);
}
}
catch (Exception ex)
{
result.Succeeded = false;
result.Errors.Add(ex.Message);
throw;
}
}
return result;
}
/// <summary>
/// 往实例文档表中添加数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
//public BaseResult AddInstance_Document(T_INSTANCE_DOCUMENT info, enum_DocumentType t)
//{
// BaseResult br = new BaseResult() { Succeeded = true, Errors = new List<string>() };
// using (BaseDB dbHelper = new OmpdDBHelper())
// {
// try
// {
// Dictionary<string, object> dic = BaseDB.EntityToDictionary(info);
// if (info.INSTANCE_DOCUMENT_ID > 0)
// {
// dbHelper.ExecuteNonQueryProc("pkg_redas_instance_document.sp_instance_document_modify", dic);
// br.ResultId = info.INSTANCE_DOCUMENT_ID;
// }
// else
// {
// dbHelper.ExecuteNonQueryProc("pkg_redas_instance_document.sp_instance_document_add", dic);
// decimal id = Convert.ToDecimal(dic["O_INSTANCE_DOCUMENT_ID"]);
// br.ResultId = id;
// //更改项目的实例ID
// if (info.Project_ID > 0)
// {
// UpdateProjectInstanceDocumentID(info.Project_ID, id, t);
// }
// if (info.Object_ID > 0)
// {
// UpdateObjectInstanceDocumentID(info.Object_ID, id, t);
// }
// }
// }
// catch (Exception ex)
// {
// br.Succeeded = false;
// br.Errors.Add("添加不成功");
// throw;
// }
// return br;
// }
//}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <param name="t">1:预估函 2：报告</param>
/// <param name="isSingleObject">是否是单标的物</param>
/// <param name="isDownLoadSort">是否是多标的物下载操作</param>
/// <returns></returns>
public BaseResult AddInstance_Document(T_INSTANCE_DOCUMENT info, EntrustItem t, bool isSingleObject, bool isDownLoadSort)
{
BaseResult br = new BaseResult()
{
Succeeded = true, Errors = new List <string>()
};
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary <string, object> dic = BaseDB.EntityToDictionary(info);
if (info.INSTANCE_DOCUMENT_ID > 0)
{
dbHelper.ExecuteNonQueryProc("pkg_redas_instance_document.sp_instance_document_modify", dic);
br.ResultId = info.INSTANCE_DOCUMENT_ID;
}
else
{
dbHelper.ExecuteNonQueryProc("pkg_redas_instance_document.sp_instance_document_add", dic);
decimal id = Convert.ToDecimal(dic["O_INSTANCE_DOCUMENT_ID"]);
br.ResultId = id;
//更改项目的实例ID 多标的物的实例保存 只要更新object表InstanceID,多标的物的下载保存 需要更新projectID
if (!isSingleObject)
{ //UpdateProjectInstanceDocumentID(info.Project_ID, id, t);
if (isDownLoadSort)
{
UpdateInstanceDocumentID(0, info.Project_ID, id, t);
}
else
{
UpdateInstanceDocumentID(info.Object_ID, 0, id, t);
}
}
else //单标的物的预估函即要更新object表InstanceID 也要更新project表的InstanceID
{
//更改object表
UpdateInstanceDocumentID(info.Object_ID, 0, id, t);
//更改project表
UpdateInstanceDocumentID(0, info.Project_ID, id, t);
}
}
}
catch (Exception ex)
{
br.Succeeded = false;
br.Errors.Add("添加不成功");
throw;
}
return(br);
}
}
/// <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>
/// 获取所有数据源
/// </summary>
/// <returns></returns>
public IList<DataSourceDTO> GetAllDataSource()
{
IList<DataSourceDTO> result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("i_Type", -1);
result = dbHelper.ExecuteListProc<DataSourceDTO>("PKG_UCS_DataSource.sp_Data_Source_get", dic);
}
catch (Exception ex)
{
}
}
return result;
}
//根据fieldID查找表单中formLabelID
private List <SELECTMODEL> GetFormLabelList(string fieldID)
{
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("i_field_id", fieldID);
var lst = dbHelper.ExecuteListProc <SELECTMODEL>("pkg_redas_build_doc.sp_form_label_get", dic);
return(lst);
}
catch
{
return(new List <SELECTMODEL>());
}
}
}
/// <summary>
/// 获得数据处理的数据源
/// </summary>
/// <returns></returns>
public IList<LabelDealWithModel> GetLabelDealSource()
{
List<LabelDealWithModel> list = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
list = dbHelper.ExecuteListProc<LabelDealWithModel>("PKG_UCS_DataSource.sp_label_deal_with_get", dic);
}
catch (Exception ex)
{
throw;
}
}
return list;
}
public IList<DataSourceDTO> GetDataSource(int templateTypeId)
{
IList<DataSourceDTO> result = new List<DataSourceDTO>();
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("i_template_type", templateTypeId);
result = dbHelper.ExecuteListProc<DataSourceDTO>("pkg_redas_build_doc.sp_data_source_get", dic);
}
catch (Exception ex)
{
result = null;
}
}
return result;
}
/// <summary>
/// 根据文档实例ID获得实例信息
/// </summary>
/// <param name="objectId"></param>
/// <param name="templateType"></param>
/// <returns></returns>
public T_INSTANCE_DOCUMENT GetInstanceDocumentGetById(decimal instanceDocumentID)
{
T_INSTANCE_DOCUMENT result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("I_INSTANCE_DOCUMENT_ID", instanceDocumentID);
List <T_INSTANCE_DOCUMENT> lst = dbHelper.ExecuteListProc <T_INSTANCE_DOCUMENT>("pkg_redas_build_doc.sp_instance_document_get", dic);
result = lst[0];
}
catch
{
}
}
return(result);
}
public IList<MotherSetDTO> GetMotherSetByCustomer(int customerId, int type)
{
IList<MotherSetDTO> result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("i_customer_ID", customerId);
dic.Add("i_document_type", type);
result = dbHelper.ExecuteListProc<MotherSetDTO>("pkg_redas_mother_set.sp_mother_set_getByCustomer", dic);
}
catch
{
result = null;
}
}
return result;
}
private string GetFormLabelList(string fieldID)
{
string value = "";
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("i_field_id", fieldID);
value = dbHelper.ExecuteScalarProc("pkg_redas_build_doc.sp_form_label_get", dic).ToString();
return value;
}
catch
{
}
}
return value;
}
/// <summary>
/// 获得数据源
/// </summary>
/// <param name="type">-1获得所有的数据源 1：获得除数据转换之外的数据源 </param>
/// <returns></returns>
public IList<DataSourceDTO> GetDataSourceByType(int type)
{
IList<DataSourceDTO> result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("i_Type", type);
result = dbHelper.ExecuteListProc<DataSourceDTO>("PKG_UCS_DataSource.sp_Data_Source_get", dic);
//提取sql中参数
ExtractSqlParms(result);
}
catch (Exception ex)
{
}
}
return result;
}
/// <summary>
/// 根据估价对象ID获得实例信息
/// </summary>
/// <param name="objectId"></param>
/// <param name="templateType"></param>
/// <returns></returns>
public T_INSTANCE_DOCUMENT GetInstanceDocumentGetByObject(decimal objectId, EntrustItem businessType)
{
T_INSTANCE_DOCUMENT result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("i_OBJECT_ID", objectId);
dic.Add("i_businessType", (int)businessType);
List <T_INSTANCE_DOCUMENT> lst = dbHelper.ExecuteListProc <T_INSTANCE_DOCUMENT>("pkg_redas_instance_document.sp_instanceDocumentGetByObject", dic);
result = lst[0];
}
catch
{
}
}
return(result);
}
public TemplateTypeDTO GetTemplateType(int templateTypeId)
{
TemplateTypeDTO result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dicParms = new Dictionary<string, object>();
dicParms.Add("i_template_type", templateTypeId);
var templateTypeList = dbHelper.ExecuteListProc<TemplateTypeDTO>("pkg_redas_build_doc.sp_template_type_get", dicParms);
if (templateTypeList.Count > 0)
{
result = templateTypeList[0];
}
}
catch {
}
return result;
}
}
public MotherSetDTO GetMotherSet(int motherId)
{
MotherSetDTO result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("i_MOTHER_SET_ID", motherId);
List<MotherSetDTO> list = null;
list = dbHelper.ExecuteListProc<MotherSetDTO>("pkg_redas_mother_set.sp_mother_set_get", dic);
if (list.Count > 0)
result = list[0];
}
catch (Exception ex)
{
throw;
}
}
return result;
}
/// <summary>
/// 获得文档实例信息
/// </summary>
/// <param name="instanceId"></param>
/// <returns></returns>
public T_INSTANCE_DOCUMENT GetInstanceInfo(int instanceId)
{
T_INSTANCE_DOCUMENT info = new T_INSTANCE_DOCUMENT();;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("i_INSTANCE_DOCUMENT_ID", instanceId);
IList <T_INSTANCE_DOCUMENT> infos = dbHelper.ExecuteListProc <T_INSTANCE_DOCUMENT>("pkg_instance_document.sp_instance_document_get", dic);
if (infos.Count > 0)
{
info = infos[0];
}
}
catch
{
}
}
return(info);
}
public DataLabelModel GetLabel(int customerId, string dataLabelName)
{
DataLabelModel result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
List<DataLabelModel> list = null;
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("i_LABEL_NAME", dataLabelName);
dic.Add("i_CUSTOMER_ID", customerId);
list = dbHelper.ExecuteListProc<DataLabelModel>("PKG_UCS_DATA_LABEL.sp_data_label_getInfoByName", dic);
}
catch
{
}
if (list.Count > 0)
result = list[0];
}
return result;
}
/// <summary>
/// 根据客户ID获得该公司下的所有构件
/// </summary>
/// <param name="customerId"></param>
/// <param name="template_Type"></param>
/// <returns></returns>
public IList<DocumentStructureDTO> GetStructuresByCustomer(decimal customerId, decimal stype, decimal dtype)
{
IList<DocumentStructureDTO> result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("i_customerId", customerId);
dic.Add("i_Structure_Type", stype);
dic.Add("i_Document_Type", dtype);
result = dbHelper.ExecuteListProc<DocumentStructureDTO>("PKG_USC_DocumentStructure.sp_structure_getByCustomer", dic);
}
catch
{
result = new List<DocumentStructureDTO>();
throw;
}
}
return result;
}
/// <summary>
/// 根据文档实例ID获得实例信息
/// </summary>
/// <param name="objectId"></param>
/// <param name="templateType"></param>
/// <returns></returns>
public InstanceDocumentDTO GetInstanceDocument(decimal instanceDocumentID)
{
InstanceDocumentDTO result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("I_INSTANCE_DOCUMENT_ID", instanceDocumentID);
List<InstanceDocumentDTO> lst = dbHelper.ExecuteListProc<InstanceDocumentDTO>("pkg_redas_build_doc.sp_instance_document_get", dic);
if (lst.Count() > 0)
{
result = lst[0];
}
}
catch
{
result = null;
}
}
return result;
}
public DocumentStructureDTO GetStructure(int structureId)
{
DocumentStructureDTO result = null;
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary<string, object> dicParms = new Dictionary<string, object>();
dicParms.Add("i_structure_id", structureId);
var list = dbHelper.ExecuteListProc<DocumentStructureDTO>("pkg_redas_build_doc.sp_doc_structure_get", dicParms);
if (list.Count() > 0)
{
result = list[0];
}
}
catch
{
result = null;
}
}
return result;
}
/// <summary>
/// 根据估价对象ID获得实例信息
/// </summary>
/// <param name="objectId"></param>
/// <param name="templateType"></param>
/// <returns></returns>
public List <_ChangeSortModel> GetObjectInstanceByProjectId(decimal projectId, EntrustItem businessType, decimal customerId)
{
List <_ChangeSortModel> result = new List <_ChangeSortModel>();
using (BaseDB dbHelper = new OmpdDBHelper())
{
try
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("i_project_id", projectId);
dic.Add("i_businessType", (int)businessType);
List <_ObjectInstance> lst = dbHelper.ExecuteListProc <_ObjectInstance>("pkg_redas_instance_document.sp_ObjectInstance_Get", dic);
string prjStructure = dic["O_PRJ_STRUCTURE"].ToString();
//获得构件的排序
IList <Document_structureModel> lstStructure = new Document_structureLogic().GetByCustomer(customerId, 0, 0);
Dictionary <decimal, decimal> dicStructureAndSort = new Dictionary <decimal, decimal>(); //优先考虑项目是否已经保存排序，为保存则读取构件中的排序
List <_ProjectStructrue> lstPrjStructure = new List <_ProjectStructrue>();
//估价对象是否更换模板
bool isChangeMotherSet = false;
if (!string.IsNullOrEmpty(prjStructure))
{
lstPrjStructure = JsonTools.JsonToObject <List <_ProjectStructrue> >(prjStructure);
//如果与数据库的模板不匹配 表示已更换模板，所以排序显示的是构件表中的排序 (多标的物)
foreach (var info in lst)
{
//info.MOTHER_SET_ID
if (lstPrjStructure.Where(p => p.MotherSetId == info.MOTHER_SET_ID).Count() <= 0)
{
isChangeMotherSet = true;
break;
}
}
}
if (isChangeMotherSet || prjStructure == "")
{
foreach (var info in lstStructure)
{
dicStructureAndSort.Add(info.STRUCTURE_ID, info.SORT_NO);
}
}
var sort = 0;
foreach (var info in lst)
{
sort++;
//实例中的所有构件
Dictionary <BlockType, List <_DocStructrue> > structureCofig = GetStructureDictionary(info.DOCUMENT_STRUCTURE);
foreach (var dicConfig in structureCofig)
{
foreach (var structure in dicConfig.Value)
{
_ChangeSortModel model = new _ChangeSortModel();
model.Object_Name = info.OBJECT_NAME;
model.StructureName = structure.Name;
model.StructureType = ((int)dicConfig.Key).ToString();
model.SturctureId = structure.Key;
model.Type = structure.Type;
model.Sort = 0;
//单标的物就按数据库中的顺序来
if (lst.Count == 1)
{
model.Sort = sort;
}
else
{
//并没有更改模板 且 数据库中已保存排序
if (!isChangeMotherSet && lstPrjStructure.Count > 0)
{
for (var i = 0; i < lstPrjStructure.Count(); i++)
{
if (lstPrjStructure[i].Key == structure.Key && lstPrjStructure[i].InstanceId == info.INSTANCE_DOCUMENT_ID)
{
model.Sort = i;
break;
}
}
}
else if (model.Type == "Config") //只有用户上传的构件才有排序
{
model.Sort = dicStructureAndSort[model.SturctureId];
}
}
model.Instance_document_id = info.INSTANCE_DOCUMENT_ID;
model.MotherSetId = info.MOTHER_SET_ID;
result.Add(model);
}
}
}
result = result.OrderBy(p => p.StructureType).ThenBy(p => p.Type).ThenBy(p => p.Sort).ToList();
}
catch
{
}
}
return(result);
}
