bool ICommon <OrganizationInfo> .Insert(OrganizationInfo organizationInfo) { Contract.Requires <ArgumentNullException>(organizationInfo != null, "参数organizationInfo:不能为空!"); Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(organizationInfo.OrgID), "参数organizationInfo.OrgID:不能为空!"); bool result = false; string message1 = string.Empty; string message2 = string.Empty; string message = string.Empty; List <string> sqls = new List <string>(); sqls.Add(DBService.InsertSql(organizationInfo, out message1)); DimOrganizationInfo dimOrg = new DimOrganizationInfo() { AreaCityID = organizationInfo.AreaCityID, AreaCityName = organizationInfo.AreaCityName, AreaCountryID = organizationInfo.AreaCountryID, AreaCountryName = organizationInfo.AreaCountryName, AreaProvinceID = organizationInfo.AreaProvinceID, AreaProvinceName = organizationInfo.AreaProvinceName, BeginTime = DateTime.Now, TradeID = organizationInfo.TradeID, //@Majichao 添加大行业维度 2016-07-15 TradeName = organizationInfo.TradeName, TradeSubID = organizationInfo.TradeSubID, //@Majichao 添加小行业维度 2016-07-15 TradeSubName = organizationInfo.TradeSubName, RegisterTypeID = organizationInfo.RegisterTypeID, RegisterTypeName = organizationInfo.RegisterTypeName, ScaleTypeID = organizationInfo.ScaleTypeID, ScaleTypeName = organizationInfo.ScaleTypeName, OrgID = organizationInfo.OrgID, ShareTypeID = organizationInfo.ShareTypeID, ShareTypeName = organizationInfo.ShareTypeName, Valid = ((int)MiicValidTypeSetting.Valid).ToString(), }; sqls.Add(DBService.InsertSql(dimOrg, out message2)); try { result = dbService.excuteSqls(sqls, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } if (result == true) { if (this.IsCached == true) { InsertCache(organizationInfo); } } return(result); }
bool ICommon <OrganizationInfo> .Update(OrganizationInfo organizationInfo) { Contract.Requires <ArgumentNullException>(organizationInfo != null, "参数organizationInfo:不能为空!"); Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(organizationInfo.OrgID), "参数organizationInfo.OrgID:不能为空,因为是主键"); string message = string.Empty; bool result = false; List <string> sqls = new List <string>(); OrganizationInfo old = ((ICommon <OrganizationInfo>) this).GetInformation(organizationInfo.OrgID); if ((organizationInfo.TradeID != null && organizationInfo.TradeName != old.TradeName) || //@Majichao IndustryCode => TradeID 2016-7-15 (organizationInfo.TradeSubID != null && organizationInfo.TradeSubName != old.TradeSubName) || (organizationInfo.RegisterTypeID != null && organizationInfo.RegisterTypeID != old.RegisterTypeID) || (organizationInfo.ShareTypeID != null && organizationInfo.ShareTypeID != old.ShareTypeID) || (organizationInfo.ScaleTypeID != null && organizationInfo.ScaleTypeID != old.ScaleTypeID) || (organizationInfo.AreaProvinceID != null && organizationInfo.AreaProvinceID != old.AreaProvinceID) || (organizationInfo.AreaCityID != null && organizationInfo.AreaCityID != old.AreaCityID) || (organizationInfo.AreaCountryID != null && organizationInfo.AreaCountryID != old.AreaCountryID) ) { string message1 = string.Empty; string message2 = string.Empty; string message3 = string.Empty; sqls.Add(DBService.UpdateSql(organizationInfo, out message1)); MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition orgIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimOrganizationInfo, string>(o => o.OrgID), organizationInfo.OrgID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, orgIDCondition)); MiicCondition validCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <DimOrganizationInfo, string>(o => o.Valid), ((int)MiicValidTypeSetting.Valid).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(validCondition)); sqls.Add(DBService.UpdateConditionsSql <DimOrganizationInfo>(new DimOrganizationInfo() { EndTime = DateTime.Now, Valid = ((int)MiicValidTypeSetting.InValid).ToString() }, condition, out message3)); DimOrganizationInfo dimOrg = new DimOrganizationInfo() { AreaCityID = organizationInfo.AreaCityID, AreaCityName = organizationInfo.AreaCityName, AreaCountryID = organizationInfo.AreaCountryID, AreaCountryName = organizationInfo.AreaCountryName, AreaProvinceID = organizationInfo.AreaProvinceID, AreaProvinceName = organizationInfo.AreaProvinceName, BeginTime = DateTime.Now, TradeID = organizationInfo.TradeID, //@Majichao 添加大行业维度 2016-07-15 TradeName = organizationInfo.TradeName, TradeSubID = organizationInfo.TradeSubID, //@Majichao 添加小行业维度 2016-07-15 TradeSubName = organizationInfo.TradeSubName, RegisterTypeID = organizationInfo.RegisterTypeID, RegisterTypeName = organizationInfo.RegisterTypeName, ScaleTypeID = organizationInfo.ScaleTypeID, ScaleTypeName = organizationInfo.ScaleTypeName, OrgID = organizationInfo.OrgID, ShareTypeID = organizationInfo.ShareTypeID, ShareTypeName = organizationInfo.ShareTypeName, Valid = ((int)MiicValidTypeSetting.Valid).ToString() }; sqls.Add(DBService.InsertSql(dimOrg, out message2)); } else { string message1 = string.Empty; sqls.Add(DBService.UpdateSql(organizationInfo, out message1)); } try { result = dbService.excuteSqls(sqls, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } if (result == true) { if (this.IsCached == true) { DeleteCache(o => o.OrgID == organizationInfo.OrgID); } } return(result); }
/// <summary> /// 新增企业信息 /// </summary> /// <param name="organizationInfo">企业信息</param> /// <param name="orgProductInfos">企业产品附件</param> /// <returns>Yes/No</returns> public bool Insert(OrganizationInfo organizationInfo, List <OrgProductInfo> orgProductInfos) { Contract.Requires <ArgumentNullException>(organizationInfo != null, "参数organizationInfo:不能为空"); bool result = false; List <string> sqls = new List <string>(); string message = string.Empty; string message1 = string.Empty; string message2 = string.Empty; string message3 = string.Empty; sqls.Add(DBService.InsertSql(organizationInfo, out message1)); DimOrganizationInfo dimOrg = new DimOrganizationInfo() { AreaCityID = organizationInfo.AreaCityID, AreaCityName = organizationInfo.AreaCityName, AreaCountryID = organizationInfo.AreaCountryID, AreaCountryName = organizationInfo.AreaCountryName, AreaProvinceID = organizationInfo.AreaProvinceID, AreaProvinceName = organizationInfo.AreaProvinceName, BeginTime = DateTime.Now, TradeID = organizationInfo.TradeID, //@Majichao 添加大行业维度 2016-07-15 TradeName = organizationInfo.TradeName, TradeSubID = organizationInfo.TradeSubID, //@Majichao 添加小行业维度 2016-07-15 TradeSubName = organizationInfo.TradeSubName, RegisterTypeID = organizationInfo.RegisterTypeID, RegisterTypeName = organizationInfo.RegisterTypeName, ScaleTypeID = organizationInfo.ScaleTypeID, ScaleTypeName = organizationInfo.ScaleTypeName, OrgID = organizationInfo.OrgID, ShareTypeID = organizationInfo.ShareTypeID, ShareTypeName = organizationInfo.ShareTypeName, Valid = ((int)MiicValidTypeSetting.Valid).ToString(), }; sqls.Add(DBService.InsertSql(dimOrg, out message2)); if (orgProductInfos != null && orgProductInfos.Count != 0) { sqls.Add(DBService.InsertsSql(orgProductInfos, out message3)); } bool fileResult = false; try { try { if (orgProductInfos != null && orgProductInfos.Count != 0) { foreach (var item in orgProductInfos) { string dest = HttpContext.Current.Server.MapPath(item.FilePath); string source = HttpContext.Current.Server.MapPath("/file/temp/OrgProduct/" + Path.GetFileName(dest)); File.Copy(source, dest, true); } } fileResult = true; } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } if (fileResult == true) { result = dbService.excuteSqls(sqls, out message); } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } if (result == true) { if (IsCached == true) { InsertCache(organizationInfo); } } return(result); }