public bool updSubMenuxAppRol(Int64 idPermisoMenu, Int64 IdPermisoSubmenu, string SumMenu, string Img, string TpoObj, string Url, string Tool, Int64 Orden, bool Activo, string App)
{
linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext();
try
{
bool bFlag = true;
dboSegLatino.sp_updSubMenuXAppRol(idPermisoMenu, IdPermisoSubmenu, SumMenu, Img, TpoObj, Url, Tool, Orden, Activo);
return(bFlag);
}
catch (Exception ex)
{
StackTrace st = new StackTrace(true);
CommonDA ComunDA = new CommonDA();
ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString());
throw new Exception(ex.Message);
}
}
public bool addRolxApp(string Rol, Int64 App)
{
linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext();
try
{
bool bFlag = true;
dboSegLatino.sp_insRolXApp(Rol, App);
return(bFlag);
}
catch (Exception ex)
{
StackTrace st = new StackTrace(true);
CommonDA ComunDA = new CommonDA();
ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString());
throw new Exception(ex.Message);
}
}
public bool updAplicacion(AplicacionBE Aplicacion, Int64 App)
{
linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext();
try
{
bool bFlag = true;
dboSegLatino.sp_updAplicacion(Aplicacion.IDAPLICACION, Aplicacion.DESCRIPCION, Aplicacion.PASSWORD, Aplicacion.ACTIVO);
return(bFlag);
}
catch (Exception ex)
{
StackTrace st = new StackTrace(true);
CommonDA ComunDA = new CommonDA();
ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString());
throw new Exception(ex.Message);
}
}
public bool addMenuxAppRol(Int64 Rol, Int64 App, string Menu, string Img, string Obj, string Url, string Tool, Int64 Orden)
{
linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext();
try
{
bool bFlag = true;
dboSegLatino.sp_insMenuXAppRol(Rol, Menu, Img, Obj, Url, Tool, Orden);
return(bFlag);
}
catch (Exception ex)
{
StackTrace st = new StackTrace(true);
CommonDA ComunDA = new CommonDA();
ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", "");
throw new Exception(ex.Message);
}
}
public bool addServicio(string Servicio)
{
linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext();
try
{
bool bFlag = true;
dboSegLatino.sp_insServicioWCF(Servicio);
return(bFlag);
}
catch (Exception ex)
{
StackTrace st = new StackTrace(true);
CommonDA ComunDA = new CommonDA();
ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", "");
throw new Exception(ex.Message);
}
}
/// <summary>
/// 查询库存变化单据
/// </summary>
/// <param name="queryFilter"></param>
/// <returns></returns>
public static QueryResult <InventoryItemCardInfo> QueryCardItemOrders(InventoryItemCardQueryFilter queryFilter)
{
if (queryFilter == null || string.IsNullOrEmpty(queryFilter.ProductSysNo))
{
throw new BusinessException("请输入商品编号");
}
if (string.IsNullOrEmpty(queryFilter.MerchantSysNo))
{
throw new BusinessException("商家编号不能为空");
}
queryFilter.CompanyCode = "8601";
//获取RMAInventoryOnlineDate:
string rmaInventoryOnlineDate = CommonDA.GetSysConfigurationValue("RMAInventoryOnlineDate", queryFilter.CompanyCode);
queryFilter.RMAInventoryOnlineDate = string.IsNullOrEmpty(rmaInventoryOnlineDate) ? new DateTime() : Convert.ToDateTime(rmaInventoryOnlineDate);
return(InventoryDA.QueryCardItemOrdersRelated(queryFilter));
}
private static decimal GetProductStepPrice(decimal oldPrice, int productSysNo, int productCount)
{
List <ProductStepPrice> productStepPrices = null;
productStepPrices = CommonDA.GetProductStepPrice(productSysNo);
if (productStepPrices == null)
{
return(oldPrice);
}
ProductStepPrice productStepPrice = productStepPrices.FirstOrDefault(c => (c.BaseCount <= productCount && productCount <= c.TopCount));
if (productStepPrice == null)
{
return(productStepPrices.FirstOrDefault(c => (c.BaseCount == 0 && 0 == c.TopCount)).StepPrice);
}
return(productStepPrice.StepPrice);
}
public RespuestaComunBE GetDefinicionTabla(string sNombreTabla)
{
CommonDA oCommonDA = new CommonDA();
ConfiguracionDA oConfiguracionDA = new ConfiguracionDA();
RespuestaComunBE Respuesta = new RespuestaComunBE();
ConfiguracionBE itemConfig = new ConfiguracionBE();
List <CatalogosBE> lsCatalogos = new List <CatalogosBE>();
string sConexionString = string.Empty;
itemConfig.psIDCONFIGAPP = ConfigurationSettings.AppSettings["IELDBConn"].ToString();
Respuesta = oConfiguracionDA.GetConfigAPP(itemConfig);
sConexionString = Respuesta.lstConfiguracion[0].psVALOR;
Respuesta = oCommonDA.GetDefinicionTabla(sNombreTabla, sConexionString);
return(Respuesta);
}
public static void SendFailedMail4SO(SOEntity soEntity, ProductGroupBuyingEntity group)
{
CustomerInfo customerInfo = CommonDA.GetCustomerBySysNo(soEntity.SOMaster.CustomerSysNo, CompanyCode);
if (customerInfo == null || customerInfo.Email == null)
{
return;
}
group.LowerLimitSellCount = CommonDA.GetLowerLimitSellCount(group.SystemNumber);
string mailFrom = "IPPSystem";
string mailTo = Util.TrimNull(customerInfo.Email);
string mailSubject = "您在新蛋的订单SO#" + soEntity.SOMaster.SystemNumber + "团购失败，订单取消";
string mailBody = BuildFailedMail(customerInfo, soEntity, group);
CommonServiceAdapter.SendEmail2MailDb(mailFrom, mailTo, null, null, mailSubject, mailBody, CompanyCode);
}
public void Run(JobContext context)
{
if (!File.Exists("LastSysncDate.txt"))
{
StreamWriter sw = File.CreateText("LastSysncDate.txt");
sw.Write("2000-01-01 00:00:00.fff");
sw.Flush();
sw.Close();
}
string str = File.ReadAllText("LastSysncDate.txt");
DateTime lastSyncDate;
if (!DateTime.TryParse(str, out lastSyncDate))
{
lastSyncDate = DateTime.Parse("2000-01-01");
}
DateTime date = CommonDA.GetDbDate();
bool isAllok = true;
System.Collections.Generic.List <SoInfo> list = CommonDA.GetSyncSo(lastSyncDate);
context.Message += string.Format("开始同步状态，发现{0}个订单\r\n", list.Count);
foreach (var item in list)
{
try
{
CommonDA.UpdateSODeclareStatus(item.SoSysno, item.SoStatus, item.StockSysNo);
}
catch (Exception ex)
{
isAllok = false;
context.Message += ex.Message;
}
}
context.Message += string.Format("\r\n同步结束\r\n", list.Count);
Log.WriteLog(context.Message, "log.txt");
if (isAllok)
{
File.WriteAllText("LastSysncDate.txt", date.ToString("yyyy-MM-dd hh:mm:ss.fff"));
}
}
public DocumentUploadDA()
{
// Initialize Variables
ErrMsg = string.Empty;
try
{
// Create an instance of the SQL Database class
_DB = new SqlDatabase(ConfigurationManager.ConnectionStrings["PROCESS360"].ToString());
}
catch (Exception err)
{
// Database Error
ErrMsg = string.Format("{0} - Connecting to Database Error - {1}",
GetType().FullName,
err.Message);
// Save the Error
CommonDA.SaveError(ErrMsg, err);
}
}
public List <UsuariosBE> GetUsuarios(UsuariosBE item, Int64 App)
{
linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext();
List <UsuariosBE> lstUsuarios = new List <UsuariosBE>();
try
{
DatosUsuarioBE DatosUsuarioRES = new DatosUsuarioBE();
var lstLector = dboSegLatino.spGetUsuarios(int.Parse(item.IDAPLICACION.ToString()), item.NOMBRE, item.AMATERNO, item.APATERNO, item.USUARIO);
foreach (var Lector in lstLector)
{
UsuariosBE itemLector = new UsuariosBE();
itemLector.IDUSUARIO = Lector.IDUSUARIO;
itemLector.IDAPLICACION = Lector.IDAPLICACION;
itemLector.DESCAREA = Lector.AREA;
itemLector.APATERNO = Lector.APATERNO;
itemLector.AMATERNO = Lector.AMATERNO;
itemLector.NOMBRE = Lector.NOMBRE;
itemLector.FECHANACCONST = Lector.FECHANACCONST;
itemLector.USUARIO = Lector.USUARIO;
itemLector.ACTIVO = bool.Parse(string.IsNullOrEmpty(Lector.ACTIVO.ToString()) ? "false" : "true");
lstUsuarios.Add(itemLector);
}
}
catch (Exception ex)
{
StackTrace st = new StackTrace(true);
CommonDA ComunDA = new CommonDA();
ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString());
throw new Exception(ex.Message);
}
finally
{
dboSegLatino.Connection.Close();
dboSegLatino.Connection.Dispose();
}
return(lstUsuarios);
}
public bool addUsuarioXAplicacion(ReglasBE Reglas, List <UsuarioXAppBE> lstUSuarioXApp, Int64 App)
{
try
{
linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext();
bool bFlag = true;
foreach (UsuarioXAppBE item in lstUSuarioXApp)
{
dboSegLatino.sp_addUsuarioXAplicacion(item.IDUSRSXAPP, item.IDAPLICACION, item.IDUSUARIO, item.ACTIVO);
}
return(bFlag);
}
catch (Exception ex)
{
StackTrace st = new StackTrace(true);
CommonDA ComunDA = new CommonDA();
ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString());
throw new Exception(ex.Message);
}
}
public bool addRolesXUsuario(ReglasBE Reglas, List <RolesXUsuarioBE> RolesXUsuario, long App)
{
try
{
linqIELDataBaseDataContext dboSegLatino = new linqIELDataBaseDataContext();
bool bFlag = true;
foreach (RolesXUsuarioBE Rol in RolesXUsuario)
{
dboSegLatino.sp_insRolesXUsuario(Rol.IDROL, Rol.IDUSUARIO, (Rol.IDESTACIONXAPP > 0 ? (Int64?)Rol.IDESTACIONXAPP : null));
}
return(bFlag);
}
catch (Exception ex)
{
StackTrace st = new StackTrace(true);
CommonDA ComunDA = new CommonDA();
ComunDA.insErrorDB("Error: " + ex.Message + " En El Metodo: " + MethodBase.GetCurrentMethod().Name, st, "", App.ToString());
throw new Exception(ex.Message);
}
}
protected void Application_Start()
{
// ロガーを取得
m_logger = LogManager.GetLogger(this.GetType());
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
// 認証カスタマイズ
AuthenticationService.Authenticating += (s, evt) =>
{
using (var dbContext = new BaseDbContext())
{
var dataAccess = new CommonDA(dbContext);
evt.Authenticated = dataAccess.Login(evt.UserName, evt.Password);
}
evt.AuthenticationIsComplete = true;
};
}
/// <summary>
/// 用户邮箱地址通过验证
/// </summary>
/// <param name="sysno"></param>
/// <returns></returns>
public static bool CustomerEmailValidated(int sysno, Point point)
{
using (var tran = TransactionManager.Create())
{
CustomerDA.CustomerEmailValidated(sysno);
PointFilter filter = new PointFilter
{
CustomerSysNo = point.CustomerSysNo,
ObtainType = point.ObtainType,
LanguageCode = ConstValue.LanguageCode,
CompanyCode = ConstValue.CompanyCode,
CurrencyCode = ConstValue.CurrencySysNo.ToString(),
StoreCompanyCode = ConstValue.StoreCompanyCode
};
if (CommonDA.ExistsPoint(filter) <= 0)
{
CommonFacade.AddPoint(point);
}
tran.Complete();
return(true);
}
return(false);
}
public ActionResult Execute(string query, string dbActive)
{
if (dbActive == "1")
{
obj = objFunc.GetDbSessionSrc();
}
else
{
obj = objFunc.GetDbSessionDes();
}
objDa = new CommonDA(obj);
DataTable dt = objDa.ExecuteSQL(query, GlobalStruct.ActionType.ExecuteDataTable, ref errMsg).ToDataTable();
if (!string.IsNullOrEmpty(errMsg))
{
return(Json(errMsg));
}
List <Dictionary <string, object> > lst = dt.ToListDictionary();
string res = lst.ToSerializer();
return(Json(res));
}
public void RunProcess()
{
List <string> messageList = CommonDA.GetMessageSuccess(_maxRecord, _ssbChannel.DataCommand);
if (messageList.Count == 0)
{
this.WriteLog(string.Format("[{0}]没有要处理的消息", _ssbChannel.Name));
return;
}
this.WriteLog(string.Format("========[{0}] Start========", _ssbChannel.Name));
foreach (var item in messageList)
{
this.ProcessMessage(item);
}
#region 异步暂时无法解决按顺序调用服务的问题
//List<List<string>> groups = SplitMessagesToGroup(messageList, 10);
//foreach (List<string> group in groups)
//{
// using (ThreadWaitHandle handler = new ThreadWaitHandle(group.Count))
// {
// foreach (string item in group)
// {
// string ssbMsg = item;
// ThreadPool.QueueUserWorkItem((object obj) =>
// {
// this.ProcessMessage(handler, ssbMsg);
// });
// }
// }
//}
#endregion
this.WriteLog(string.Format("========[{0}] End========", _ssbChannel.Name));
}
public ActionResult CountTotal(string tableName, string dbActive)
{
if (dbActive == "1")
{
obj = objFunc.GetDbSessionSrc();
}
else
{
obj = objFunc.GetDbSessionDes();
}
objDa = new CommonDA(obj);
string sql = "SELECT COUNT(1) FROM " + tableName;
object r = objDa.ExecuteSQL(sql, GlobalStruct.ActionType.ExecuteScalar, ref errMsg);
if (!string.IsNullOrEmpty(errMsg))
{
return(Json(errMsg));
}
string total = string.Format("{0:n0}", r.ToInt32());
string res = "Total rows of table " + tableName + ": " + total;
return(Json(res));
}
public static Area GetArea(int district)
{
return(CommonDA.GetAreaBySysNo(district));
}
public static bool InsertNewSMS(SMSInfo item)
{
item.IPAddress = GetIP();
return(CommonDA.InsertNewSMS(item));
}
/// <summary>
/// 获取省份下所有的城市
/// </summary>
/// <param name="proviceSysNo"></param>
/// <returns></returns>
public static List <Area> GetAllCity(int proviceSysNo)
{
return(CommonDA.GetAllCity(proviceSysNo));
}
/// <summary>
/// 获取城市下所有的地区
/// </summary>
/// <returns></returns>
public static List <Area> GetAllDistrict(int citySysNo)
{
return(CommonDA.GetAllDistrict(citySysNo));
}
/// <summary>
/// 根据PageTypeID获取页面类型
/// </summary>
/// <param name="sysNo">编号</param>
/// <returns></returns>
public static PageType GetPageType(int pageTypeID)
{
return(CommonDA.GetPageType(pageTypeID));
}
/// <summary>
/// 获取所有的省份
/// </summary>
/// <param name="regionSysNo"></param>
/// <returns></returns>
public static List <Area> GetAllProvince()
{
return(CommonDA.GetAllProvince());
}
public static void Run(JobContext context)
{
string startJobString = "\r\n\r\n\r\n====================================================================\r\n";
startJobString += string.Format("====================={0}=====================\r\n", DateTime.Now.ToString("yyyy年MM月dd日 HH:mm:ss:fffff"));
startJobString += "=====================Job启动=====================\r\n";
Util.WriteLog(startJobString, context, Config.Debug);
Util.WriteLog("正在检索渠道商……");
List <int> channelSysNos = CommonDA.GetAllChannel();
int[] exists = Config.ExistsChannelSysNo;
for (int i = 0; i < exists.Length; i++)
{
channelSysNos.Remove(exists[i]);
}
string[] arr = channelSysNos.Select(item => item.ToString()).ToArray();
Util.WriteLog(string.Format("共检索渠道商{0}个({1})", channelSysNos.Count, string.Join(",", arr)));
//ChannelInventoryBaseBP bp1 = new ChannelProductPercentBP(context);
//ChannelInventoryRun run1 = new ChannelInventoryRun(bp1.Run);
Queue <ChannelInventoryRun> bizQueue = new Queue <ChannelInventoryRun>();
Queue <IAsyncResult> asyncResultQueue = new Queue <IAsyncResult>();
Util.WriteLog("开始渠道库存同步……");
foreach (int channel in channelSysNos)
{
ChannelInventoryBaseBP biz = new ChannelProductPercentBP(context, channel);
ChannelInventoryRun run = new ChannelInventoryRun(biz.Run);
IAsyncResult result = run.BeginInvoke(null, null);
bizQueue.Enqueue(run);
asyncResultQueue.Enqueue(result);
}
//ChannelInventoryBaseBP bpTaoBao = new TaoBaoChannelProductPercentBP(context);
//ChannelInventoryRun runTaoBo = new ChannelInventoryRun(bpTaoBao.Run);
//IAsyncResult resultTaoBo = runTaoBo.BeginInvoke(null, null);
//ChannelInventoryBaseBP bpDF = new DFChannelProductPercentBP(context);
//ChannelInventoryRun runDF = new ChannelInventoryRun(bpDF.Run);
//IAsyncResult resultDF = runDF.BeginInvoke(null, null);
//ChannelInventoryBaseBP bpCM = new CMChannelProductPercentBP(context);
//ChannelInventoryRun runCM = new ChannelInventoryRun(bpCM.Run);
//IAsyncResult resultCM = runCM.BeginInvoke(null, null);
//ChannelInventoryBaseBP bpJSB = new JSBChannelProductPercentBP(context);
//ChannelInventoryRun runJSB = new ChannelInventoryRun(bpJSB.Run);
//IAsyncResult resultJSB = runJSB.BeginInvoke(null, null);
ChannelInventoryBaseBP bpAppoint = new ChannelProductAppointBP(context);
ChannelInventoryRun runAppoint = new ChannelInventoryRun(bpAppoint.Run);
IAsyncResult resultAppoint = runAppoint.BeginInvoke(null, null);
try
{
runAppoint.EndInvoke(resultAppoint);
}
catch (Exception ex)
{
ExceptionHelper.HandleException(ex);
Util.WriteLog(ex.Message, context, Config.Debug);
Util.WriteLog(ex.StackTrace, context, Config.Debug);
}
while (bizQueue.Count > 0)
{
ChannelInventoryRun run = bizQueue.Dequeue();
IAsyncResult result = asyncResultQueue.Dequeue();
try
{
run.EndInvoke(result);
}
catch (Exception ex)
{
ExceptionHelper.HandleException(ex);
Util.WriteLog(ex.Message, context, Config.Debug);
Util.WriteLog(ex.StackTrace, context, Config.Debug);
}
}
//try
//{
// runJSB.EndInvoke(resultJSB);
//}
//catch (Exception ex)
//{
// ExceptionHelper.HandleException(ex);
// Util.WriteLog(ex.Message, context, Config.Debug);
// Util.WriteLog(ex.StackTrace, context, Config.Debug);
//}
//try
//{
// runCM.EndInvoke(resultCM);
//}
//catch (Exception ex)
//{
// ExceptionHelper.HandleException(ex);
// Util.WriteLog(ex.Message, context, Config.Debug);
// Util.WriteLog(ex.StackTrace, context, Config.Debug);
//}
//try
//{
// runDF.EndInvoke(resultDF);
//}
//catch (Exception ex)
//{
// ExceptionHelper.HandleException(ex);
// Util.WriteLog(ex.Message, context, Config.Debug);
// Util.WriteLog(ex.StackTrace, context, Config.Debug);
//}
//try
//{
// runTaoBo.EndInvoke(resultTaoBo);
//}
//catch (Exception ex)
//{
// ExceptionHelper.HandleException(ex);
// Util.WriteLog(ex.Message, context, Config.Debug);
// Util.WriteLog(ex.StackTrace, context, Config.Debug);
//}
Util.WriteLog("渠道库存同步完成", context, Config.Debug);
Util.WriteLog("Job退出", context, Config.Debug);
if (Config.Debug)
{
ThreadPool.QueueUserWorkItem(new WaitCallback(WriteFile), context.Message);
}
}
public void Sort(IEnumerable <SortItem> items)
{
CommonDA.Sort("[Group]", items, "");
}
public static void WriteLog(int sysNo, string type, string memo)
{
CommonDA.WriteProcessLog(sysNo, type, memo);
}
public static void EndGroupBuying(int groupBuyingSysNo)
{
CommonDA.ChangeGroupBuySettlement(groupBuyingSysNo, "Y", CompanyCode);
}
public static bool ExistsNetPay(int soSysNo)
{
return(CommonDA.ExistsNetPay(soSysNo, CompanyCode));
}
