public bool Logoff(string random) { #region 認証処理 string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; string _message = ""; userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(false); } #endregion return(pvtLogoff(ipAdress, userId, sessionString, personId)); }
public void AddEvidence(string random, string pgId, int type, string memo) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".AddEvidence(認証処理)", ex); return; } #endregion gAddEvidence(1, companyId, userId, ipAdress, sessionString, pgId, (DataPgEvidence.geOperationType)type, memo); }
public void LockPg(string random, string pgId, string lockId, int type) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UnLockPg(認証処理)", ex); return; } #endregion try { ExMySQLData db = ExSession.GetSessionDb(ExCast.zCInt(userId), sessionString); DataPgLock.geLovkFlg lockFlg; if (type == 0) { DataPgLock.DelLockPg(companyId, userId, pgId, lockId, ipAdress, true, db); } else { DataPgLock.SetLockPg(companyId, userId, pgId, lockId, ipAdress, db, out lockFlg); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UnLockPg", ex); return; } }
public string UpdateInvoiceBalance(string random, int type, List <EntityInvoiceBalance> entity) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(認証処理)", ex); return(CLASS_NM + ".UpdateInvoiceBalance : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string _Id = ""; int _classKbn = 0; #endregion #region Databese Open try { db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR])); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(DbOpen)", ex); return(CLASS_NM + ".UpdateInvoiceBalance(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(BeginTransaction)", ex); return(CLASS_NM + ".UpdateInvoiceBalance(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Update if (type == 0) { try { for (int i = 0; i <= entity.Count - 1; i++) { if (entity[i].exec_flg == true) { double upd_balance = entity[i].before_invoice_price_upd - entity[i].before_invoice_price; #region Update Invoice Balance try { sb.Length = 0; sb.Append("UPDATE T_INVOICE " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 0)); sb.Append(" ,BEFORE_INVOICE_PRICE = BEFORE_INVOICE_PRICE + " + upd_balance + Environment.NewLine); sb.Append(" ,TRANSFER_PRICE = TRANSFER_PRICE + " + upd_balance + Environment.NewLine); sb.Append(" ,INVOICE_PRICE = INVOICE_PRICE + " + upd_balance + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine); sb.Append(" AND INVOICE_KBN = 0 " + Environment.NewLine); sb.Append(" AND INVOICE_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(entity[i].invoice_id)) + Environment.NewLine); db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(Update Invoice Balance)", ex); return(CLASS_NM + ".UpdateInvoiceBalance(Update Invoice Balance) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion } } } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(Insert)", ex); return(CLASS_NM + ".UpdateInvoiceBalance(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region PG排他制御 //try //{ // DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); //} //catch (Exception ex) //{ // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(DelLockPg)", ex); // return CLASS_NM + ".UpdateInvoiceBalance(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; //} #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(CommitTransaction)", ex); return(CLASS_NM + ".UpdateInvoiceBalance(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(DbClose)", ex); return(CLASS_NM + ".UpdateInvoiceBalance(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.DeleteAndInsert, ""); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(Add Evidence)", ex); return(CLASS_NM + ".UpdateInvoiceBalance(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion return(""); }
public List <EntityInvoiceBalance> GetInvoiceBalanceList(string random, string strWhereSql, string strOrderBySql) { List <EntityInvoiceBalance> entityList = new List <EntityInvoiceBalance>(); #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; int idFigureCommodity = 0; int idFigureCustomer = 0; int idFigurePurchase = 0; int idFigureSlipNo = 0; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); idFigureCommodity = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_GOODS]); idFigureCustomer = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_CUSTOMER]); idFigurePurchase = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_PURCHASE]); idFigureSlipNo = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_SLIP_NO]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { EntityInvoiceBalance entity = new EntityInvoiceBalance(); entity.MESSAGE = _message; entityList.Add(entity); return(entityList); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetInvoiceBalanceList(認証処理)", ex); EntityInvoiceBalance entity = new EntityInvoiceBalance(); entity.MESSAGE = "認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();; entityList.Add(entity); return(entityList); } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); ExReportManeger rptMgr = new ExReportManeger(); rptMgr.idFigureCommodity = idFigureCommodity; rptMgr.idFigureCustomer = idFigureCustomer; rptMgr.idFigurePurchase = idFigurePurchase; rptMgr.idFigureSlipNo = idFigureSlipNo; sb.Append(rptMgr.GetInvoiceBalanceListReportSQL(companyId, groupId, strWhereSql, strOrderBySql)); dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { #region Set Entity EntityInvoiceBalance entity = new EntityInvoiceBalance(); entity.no = ExCast.zCStr(dt.DefaultView[i]["NO"]); entity.invoice_id = ExCast.zCStr(dt.DefaultView[i]["INVOICE_ID"]); entity.invoice_nm = ExCast.zCStr(dt.DefaultView[i]["INVOICE_NM"]); entity.invoice_yyyymmdd = ExCast.zDateNullToDefault(dt.DefaultView[i]["INVOICE_YYYYMMDD"]); entity.summing_up_group_id = ExCast.zCStr(dt.DefaultView[i]["SUMMING_UP_GROUP_ID"]); entity.summing_up_group_nm = ExCast.zCStr(dt.DefaultView[i]["SUMMING_UP_GROUP_NM"]); entity.person_id = ExCast.zCInt(dt.DefaultView[i]["INPUT_PERSON"]); entity.person_nm = ExCast.zCStr(dt.DefaultView[i]["INPUT_PERSON_NM"]); entity.collect_plan_day = ExCast.zDateNullToDefault(dt.DefaultView[i]["COLLECT_PLAN_DAY"]); entity.collect_day = ExCast.zCInt(dt.DefaultView[i]["COLLECT_DAY"]); entity.before_invoice_yyyymmdd = ExCast.zDateNullToDefault(dt.DefaultView[i]["BEFORE_INVOICE_YYYYMMDD"]); entity.before_invoice_price = ExCast.zCDbl(dt.DefaultView[i]["BEFORE_INVOICE_PRICE"]); entity.before_invoice_price_upd = ExCast.zCDbl(dt.DefaultView[i]["BEFORE_INVOICE_PRICE"]); entity.receipt_price = ExCast.zCDbl(dt.DefaultView[i]["RECEIPT_PRICE"]); entity.transfer_price = ExCast.zCDbl(dt.DefaultView[i]["TRANSFER_PRICE"]); entity.sales_price = ExCast.zCDbl(dt.DefaultView[i]["SALES_PRICE"]); entity.no_tax_sales_price = ExCast.zCDbl(dt.DefaultView[i]["NO_TAX_SALES_PRICE"]); entity.tax = ExCast.zCDbl(dt.DefaultView[i]["TAX"]); entity.invoice_price = ExCast.zCDbl(dt.DefaultView[i]["INVOICE_PRICE"]); entity.invoice_kbn = ExCast.zCInt(dt.DefaultView[i]["INVOICE_KBN"]); entity.invoice_kbn_nm = ExCast.zCStr(dt.DefaultView[i]["INVOICE_KBN_NM"]); entity.memo = ExCast.zCStr(dt.DefaultView[i]["MEMO"]); entity.invoice_exists_flg = 0; entity.exec_flg = false; entity.lock_flg = 0; entityList.Add(entity); #endregion } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetInvoiceBalanceList", ex); entityList.Clear(); EntityInvoiceBalance entity = new EntityInvoiceBalance(); entity.MESSAGE = CLASS_NM + ".GetInvoiceBalanceList : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); entityList.Add(entity); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, DataPgEvidence.PGName.Order.OrderList, DataPgEvidence.geOperationType.Select, "Where:" + strWhereSql + ",Orderby:" + strOrderBySql); return(entityList); }
public List <EntityStockInventory> GetStockInventoryList(string random, string strWhereSql, string strOrderBySql) { List <EntityStockInventory> entityList = new List <EntityStockInventory>(); #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; int idFigureCommodity = 0; int idFigureCustomer = 0; int idFigurePurchase = 0; int idFigureSlipNo = 0; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); idFigureCommodity = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_GOODS]); idFigureCustomer = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_CUSTOMER]); idFigurePurchase = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_PURCHASE]); idFigureSlipNo = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_SLIP_NO]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { EntityStockInventory entity = new EntityStockInventory(); entity.MESSAGE = _message; entityList.Add(entity); return(entityList); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetStockInventoryList(認証処理)", ex); EntityStockInventory entity = new EntityStockInventory(); entity.MESSAGE = "認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();; entityList.Add(entity); return(entityList); } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); ExReportManeger rptMgr = new ExReportManeger(); rptMgr.idFigureCommodity = idFigureCommodity; rptMgr.idFigureCustomer = idFigureCustomer; rptMgr.idFigurePurchase = idFigurePurchase; rptMgr.idFigureSlipNo = idFigureSlipNo; sb.Append(rptMgr.GetStockInventoryListReportSQL(companyId, groupId, strWhereSql, strOrderBySql)); dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { #region Set Entity EntityStockInventory entity = new EntityStockInventory(); entity.commodity_id = ExCast.zCStr(dt.DefaultView[i]["COMMODITY_ID"]); entity.commodity_name = ExCast.zCStr(dt.DefaultView[i]["COMMODITY_NAME"]); entity.account_inventory_number = ExCast.zCDbl(dt.DefaultView[i]["INVENTORY_NUMBER"]); entity.practice_inventory_number = ExCast.zCDbl(dt.DefaultView[i]["INVENTORY_NUMBER"]); entity.diff_number = 0; entity.exec_flg = false; entity.lock_flg = 0; entityList.Add(entity); #endregion } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetStockInventoryList", ex); entityList.Clear(); EntityStockInventory entity = new EntityStockInventory(); entity.MESSAGE = CLASS_NM + ".GetStockInventoryList : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); entityList.Add(entity); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, DataPgEvidence.PGName.StockInventory.StockInventoryInp, DataPgEvidence.geOperationType.Select, "Where:" + strWhereSql + ",Orderby:" + strOrderBySql); return(entityList); }
public string UpdateReportSetting(string random, int type, string Id, EntityReportSetting entity) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(認証処理)", ex); return(CLASS_NM + ".UpdateReportSetting : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string _Id = Id; #endregion #region Databese Open try { db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR])); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(DbOpen)", ex); return(CLASS_NM + ".UpdateReportSetting(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(BeginTransaction)", ex); return(CLASS_NM + ".UpdateReportSetting(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Insert if (type <= 1) { try { #region Delete SQL sb.Length = 0; sb.Append("DELETE FROM M_REPORT_SETTING " + Environment.NewLine); sb.Append(" WHERE USER_ID = " + userId + Environment.NewLine); sb.Append(" AND PG_ID = " + ExEscape.zRepStr(Id) + Environment.NewLine); #endregion db.ExecuteSQL(sb.ToString(), false); #region Insert SQL sb.Length = 0; sb.Append("INSERT INTO M_REPORT_SETTING " + Environment.NewLine); sb.Append(" ( USER_ID" + Environment.NewLine); sb.Append(" , PG_ID" + Environment.NewLine); sb.Append(" , SIZE" + Environment.NewLine); sb.Append(" , ORIENTATION" + Environment.NewLine); sb.Append(" , LEFT_MARGIN" + Environment.NewLine); sb.Append(" , RIGHT_MARGIN" + Environment.NewLine); sb.Append(" , TOP_MARGIN" + Environment.NewLine); sb.Append(" , BOTTOM_MARGIN" + Environment.NewLine); sb.Append(" , GROUP_ID_FROM" + Environment.NewLine); sb.Append(" , GROUP_ID_TO" + Environment.NewLine); sb.Append(" , GROUP_TOTAL" + Environment.NewLine); sb.Append(" , TOTAL_KBN" + Environment.NewLine); sb.Append(" , UPDATE_FLG" + Environment.NewLine); sb.Append(" , DELETE_FLG" + Environment.NewLine); sb.Append(" , CREATE_PG_ID" + Environment.NewLine); sb.Append(" , CREATE_ADRESS" + Environment.NewLine); sb.Append(" , CREATE_USER_ID" + Environment.NewLine); sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine); sb.Append(" , CREATE_DATE" + Environment.NewLine); sb.Append(" , CREATE_TIME" + Environment.NewLine); sb.Append(" , UPDATE_PG_ID" + Environment.NewLine); sb.Append(" , UPDATE_ADRESS" + Environment.NewLine); sb.Append(" , UPDATE_USER_ID" + Environment.NewLine); sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine); sb.Append(" , UPDATE_DATE" + Environment.NewLine); sb.Append(" , UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("SELECT " + userId + Environment.NewLine); // USER_ID sb.Append(" ," + ExEscape.zRepStr(_Id) + Environment.NewLine); // PG_ID sb.Append(" ," + entity.size + Environment.NewLine); // SIZE sb.Append(" ," + entity.orientation + Environment.NewLine); // ORIENTATION sb.Append(" ," + entity.left_margin + Environment.NewLine); // LEFT_MARGIN sb.Append(" ," + entity.right_margin + Environment.NewLine); // RIGHT_MARGIN sb.Append(" ," + entity.top_margin + Environment.NewLine); // TOP_MARGIN sb.Append(" ," + entity.bottom_margin + Environment.NewLine); // BOTTOM_MARGIN sb.Append(" ," + entity.group_id_from + Environment.NewLine); // GROUP_ID_FROM sb.Append(" ," + entity.group_id_to + Environment.NewLine); // GROUP_ID_TO sb.Append(" ," + entity.group_total + Environment.NewLine); // GROUP_TOTAL sb.Append(" ," + entity.total_kbn + Environment.NewLine); // TOTAL_KBN sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins, PG_NM, "M_REPORT_SETTING", ExCast.zCInt(personId), _Id, ipAdress, userId)); #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(Insert)", ex); return(CLASS_NM + ".UpdateReportSetting(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Update if (type == 0) { //try //{ // #region SQL // string _invoice_id = entity.invoice_id; // if (ExCast.IsNumeric(_invoice_id)) _invoice_id = ExCast.zCDbl(_invoice_id).ToString(); // sb.Length = 0; // sb.Append("UPDATE M_REPORT_SETTING " + Environment.NewLine); // sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, // ExCast.zCInt(personId), // ipAdress, // userId, // 0)); // sb.Append(" ,NAME = " + ExEscape.zRepStr(entity.name) + Environment.NewLine); // sb.Append(" ,KANA = " + ExEscape.zRepStr(entity.kana) + Environment.NewLine); // sb.Append(" ,ABOUT_NAME = " + ExEscape.zRepStr(entity.about_name) + Environment.NewLine); // sb.Append(" ,ZIP_CODE = " + ExCast.zNullToZero(entity.zip_code_from + entity.zip_code_to) + Environment.NewLine); // sb.Append(" ,PREFECTURE_ID = " + entity.prefecture_id + Environment.NewLine); // sb.Append(" ,CITY_ID = " + entity.city_id + Environment.NewLine); // sb.Append(" ,TOWN_ID = " + entity.town_id + Environment.NewLine); // sb.Append(" ,ADRESS_CITY = " + ExEscape.zRepStr(entity.adress_city) + Environment.NewLine); // sb.Append(" ,ADRESS_TOWN = " + ExEscape.zRepStr(entity.adress_town) + Environment.NewLine); // sb.Append(" ,ADRESS1 = " + ExEscape.zRepStr(entity.adress1) + Environment.NewLine); // sb.Append(" ,ADRESS2 = " + ExEscape.zRepStr(entity.adress2) + Environment.NewLine); // sb.Append(" ,STATION_NAME = " + ExEscape.zRepStr(entity.station_name) + Environment.NewLine); // sb.Append(" ,POST_NAME = " + ExEscape.zRepStr(entity.post_name) + Environment.NewLine); // sb.Append(" ,PERSON_NAME = " + ExEscape.zRepStr(entity.person_name) + Environment.NewLine); // sb.Append(" ,TITLE_ID = " + entity.title_id + Environment.NewLine); // sb.Append(" ,TITLE_NAME = " + ExEscape.zRepStr(entity.title_name) + Environment.NewLine); // sb.Append(" ,TEL = " + ExEscape.zRepStr(entity.tel) + Environment.NewLine); // sb.Append(" ,FAX = " + ExEscape.zRepStr(entity.fax) + Environment.NewLine); // sb.Append(" ,MAIL_ADRESS = " + ExEscape.zRepStr(entity.mail_adress) + Environment.NewLine); // sb.Append(" ,MOBILE_TEL = " + ExEscape.zRepStr(entity.mobile_tel) + Environment.NewLine); // sb.Append(" ,MOBILE_ADRESS = " + ExEscape.zRepStr(entity.mobile_adress) + Environment.NewLine); // sb.Append(" ,URL = " + ExEscape.zRepStr(entity.url) + Environment.NewLine); // sb.Append(" ,INVOICE_ID = " + ExEscape.zRepStr(_invoice_id) + Environment.NewLine); // sb.Append(" ,BUSINESS_DIVISION_ID = " + entity.business_division_id + Environment.NewLine); // sb.Append(" ,UNIT_KIND_ID = " + entity.unit_kind_id + Environment.NewLine); // sb.Append(" ,CREDIT_RATE = " + entity.credit_rate + Environment.NewLine); // sb.Append(" ,TAX_CHANGE_ID = " + entity.tax_change_id + Environment.NewLine); // sb.Append(" ,SUMMING_UP_GROUP_ID = " + ExEscape.zRepStr(entity.summing_up_group_id) + Environment.NewLine); // sb.Append(" ,PRICE_FRACTION_PROC_ID = " + entity.price_fraction_proc_id + Environment.NewLine); // sb.Append(" ,TAX_FRACTION_PROC_ID = " + entity.tax_fraction_proc_id + Environment.NewLine); // sb.Append(" ,CREDIT_LIMIT_PRICE = " + entity.credit_limit_price + Environment.NewLine); // sb.Append(" ,SALES_CREDIT_PRICE = " + entity.sales_credit_price + Environment.NewLine); // sb.Append(" ,RECEIPT_DIVISION_ID = " + ExEscape.zRepStr(entity.receipt_division_id) + Environment.NewLine); // sb.Append(" ,COLLECT_CYCLE_ID = " + entity.collect_cycle_id + Environment.NewLine); // sb.Append(" ,COLLECT_DAY = " + entity.collect_day + Environment.NewLine); // sb.Append(" ,BILL_SITE = " + entity.bill_site + Environment.NewLine); // sb.Append(" ,GROUP1_ID = " + ExEscape.zRepStr(entity.group1_id) + Environment.NewLine); // sb.Append(" ,GROUP2_ID = " + ExEscape.zRepStr(entity.group2_id) + Environment.NewLine); // sb.Append(" ,GROUP3_ID = " + ExEscape.zRepStr(entity.group3_id) + Environment.NewLine); // sb.Append(" ,MEMO = " + ExEscape.zRepStr(entity.memo) + Environment.NewLine); // sb.Append(" ,DISPLAY_FLG = " + entity.display_division_id + Environment.NewLine); // sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID // sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID // #endregion // db.ExecuteSQL(sb.ToString(), false); //} //catch (Exception ex) //{ // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(Update)", ex); // return CLASS_NM + ".UpdateReportSetting(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; //} } #endregion #region Delete //if (type == 2) //{ // #region Exist Data // try // { // bool _ret = false; // _ret = DataExists.IsExistData(db, companyId, "", "M_REPORT_SETTING", "INVOICE_ID", ExCast.zNumZeroNothingFormat(Id), "ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String); // if (_ret == true) // { // return "得意先ID : " + Id + " は得意先マスタの請求IDにが使用されている為、削除できません。"; // } // _ret = DataExists.IsExistData(db, companyId, "", "T_ORDER_H", "ReportSetting_ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String); // if (_ret == true) // { // return "得意先ID : " + Id + " は受注データの得意先に使用されている為、削除できません。"; // } // } // catch (Exception ex) // { // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(Exist Data)", ex); // return CLASS_NM + ".UpdateReportSetting(Exist Data) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; // } // #endregion // #region Update // try // { // sb.Length = 0; // sb.Append("UPDATE M_REPORT_SETTING " + Environment.NewLine); // sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, // ExCast.zCInt(personId), // ipAdress, // userId, // 1)); // sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID // sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID // db.ExecuteSQL(sb.ToString(), false); // } // catch (Exception ex) // { // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(Delete)", ex); // return CLASS_NM + ".UpdateReportSetting(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; // } // #endregion //} #endregion #region PG排他制御 //if (type == 0 || type == 2) //{ // try // { // DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); // } // catch (Exception ex) // { // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(DelLockPg)", ex); // return CLASS_NM + ".UpdateReportSetting(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; // } //} #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(CommitTransaction)", ex); return(CLASS_NM + ".UpdateReportSetting(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(DbClose)", ex); return(CLASS_NM + ".UpdateReportSetting(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { switch (type) { case 0: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Update, "ID:" + _Id.ToString()); break; case 1: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Insert, "ID:" + _Id.ToString()); break; case 2: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Delete, "ID:" + Id.ToString()); break; default: break; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateReportSetting(Add Evidence)", ex); return(CLASS_NM + ".UpdateReportSetting(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Return return(""); //if (type == 1 && (Id == "0" || Id == "")) //{ // return "Auto Insert success : " + "ID : " + _Id.ToString() + "で登録しました。"; //} //else //{ // return ""; //} #endregion }
public string UpdateCommodity(string random, int type, string Id, EntityCommodity entity) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(認証処理)", ex); return(CLASS_NM + ".UpdateCommodity : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string _Id = ""; #endregion #region Databese Open try { db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR])); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(DbOpen)", ex); return(CLASS_NM + ".UpdateCommodity(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(BeginTransaction)", ex); return(CLASS_NM + ".UpdateCommodity(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Get Max Master ID if (type == 1 && (Id == "" || Id == "0")) { try { DataMasterId.GetMaxMasterId(companyId, "", db, DataMasterId.geMasterMaxIdKbn.Commodity, out _Id); if (_Id == "") { return("ID取得に失敗しました。"); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(GetMaxMasterId)", ex); return(CLASS_NM + ".UpdateCommodity(GetMaxMasterId) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } else { _Id = Id; } #endregion #region Insert if (type == 1) { try { #region Delete SQL sb.Length = 0; sb.Append("DELETE FROM M_COMMODITY " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 1 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); #endregion db.ExecuteSQL(sb.ToString(), false); #region Insert SQL string _main_purchase_id = entity.main_purchase_id; if (ExCast.IsNumeric(_main_purchase_id)) { _main_purchase_id = ExCast.zCDbl(_main_purchase_id).ToString(); } #region SQL sb.Length = 0; sb.Append("INSERT INTO M_COMMODITY " + Environment.NewLine); sb.Append(" ( COMPANY_ID" + Environment.NewLine); sb.Append(" , ID" + Environment.NewLine); sb.Append(" , ID2" + Environment.NewLine); sb.Append(" , NAME" + Environment.NewLine); sb.Append(" , KANA" + Environment.NewLine); sb.Append(" , UNIT_ID" + Environment.NewLine); sb.Append(" , ENTER_NUMBER" + Environment.NewLine); sb.Append(" , NUMBER_DECIMAL_DIGIT" + Environment.NewLine); sb.Append(" , UNIT_DECIMAL_DIGIT" + Environment.NewLine); sb.Append(" , TAXATION_DIVISION_ID" + Environment.NewLine); sb.Append(" , INVENTORY_MANAGEMENT_DIVISION_ID" + Environment.NewLine); sb.Append(" , PURCHASE_LOT" + Environment.NewLine); sb.Append(" , LEAD_TIME" + Environment.NewLine); sb.Append(" , JUST_INVENTORY_NUMBER" + Environment.NewLine); sb.Append(" , INVENTORY_NUMBER" + Environment.NewLine); sb.Append(" , INVENTORY_EVALUATION_ID" + Environment.NewLine); sb.Append(" , MAIN_PURCHASE_ID" + Environment.NewLine); sb.Append(" , RETAIL_PRICE_SKIP_TAX" + Environment.NewLine); sb.Append(" , RETAIL_PRICE_BEFORE_TAX" + Environment.NewLine); sb.Append(" , SALES_UNIT_PRICE_SKIP_TAX" + Environment.NewLine); sb.Append(" , SALES_UNIT_PRICE_BEFORE_TAX" + Environment.NewLine); sb.Append(" , SALES_COST_PRICE_SKIP_TAX" + Environment.NewLine); sb.Append(" , SALES_COST_PRICE_BEFORE_TAX" + Environment.NewLine); sb.Append(" , PURCHASE_UNIT_PRICE_SKIP_TAX" + Environment.NewLine); sb.Append(" , PURCHASE_UNIT_PRICE_BEFORE_TAX" + Environment.NewLine); sb.Append(" , GROUP1_ID" + Environment.NewLine); sb.Append(" , GROUP2_ID" + Environment.NewLine); sb.Append(" , GROUP3_ID" + Environment.NewLine); sb.Append(" , MEMO" + Environment.NewLine); sb.Append(" , DISPLAY_FLG" + Environment.NewLine); sb.Append(" , UPDATE_FLG" + Environment.NewLine); sb.Append(" , DELETE_FLG" + Environment.NewLine); sb.Append(" , CREATE_PG_ID" + Environment.NewLine); sb.Append(" , CREATE_ADRESS" + Environment.NewLine); sb.Append(" , CREATE_USER_ID" + Environment.NewLine); sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine); sb.Append(" , CREATE_DATE" + Environment.NewLine); sb.Append(" , CREATE_TIME" + Environment.NewLine); sb.Append(" , UPDATE_PG_ID" + Environment.NewLine); sb.Append(" , UPDATE_ADRESS" + Environment.NewLine); sb.Append(" , UPDATE_USER_ID" + Environment.NewLine); sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine); sb.Append(" , UPDATE_DATE" + Environment.NewLine); sb.Append(" , UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("SELECT " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); // ID sb.Append(" ," + ExCast.zIdForNumIndex(_Id) + Environment.NewLine); // ID2 sb.Append(" ," + ExEscape.zRepStr(entity.name) + Environment.NewLine); // NAME sb.Append(" ," + ExEscape.zRepStr(entity.kana) + Environment.NewLine); // KANA sb.Append(" ," + entity.unit_id + Environment.NewLine); // UNIT_ID sb.Append(" ," + entity.enter_number + Environment.NewLine); // ENTER_NUMBER sb.Append(" ," + entity.number_decimal_digit + Environment.NewLine); // NUMBER_DECIMAL_DIGIT sb.Append(" ," + entity.unit_decimal_digit + Environment.NewLine); // UNIT_DECIMAL_DIGIT sb.Append(" ," + entity.taxation_divition_id + Environment.NewLine); // TAXATION_DIVISION_ID sb.Append(" ," + entity.inventory_management_division_id + Environment.NewLine); // INVENTORY_MANAGEMENT_DIVISION_ID sb.Append(" ," + entity.purchase_lot + Environment.NewLine); // PURCHASE_LOT sb.Append(" ," + entity.lead_time + Environment.NewLine); // LEAD_TIME sb.Append(" ," + entity.just_inventory_number + Environment.NewLine); // JUST_INVENTORY_NUMBER sb.Append(" ," + entity.inventory_number + Environment.NewLine); // INVENTORY_NUMBER sb.Append(" ," + entity.inventory_evaluation_id + Environment.NewLine); // INVENTORY_EVALUATION_ID sb.Append(" ," + ExEscape.zRepStr(_main_purchase_id) + Environment.NewLine); // MAIN_PURCHASE_ID sb.Append(" ," + entity.retail_price_skip_tax + Environment.NewLine); // RETAIL_PRICE_SKIP_TAX sb.Append(" ," + entity.retail_price_before_tax + Environment.NewLine); // RETAIL_PRICE_BEFORE_TAX sb.Append(" ," + entity.sales_unit_price_skip_tax + Environment.NewLine); // SALES_UNIT_PRICE_SKIP_TAX sb.Append(" ," + entity.sales_unit_price_before_tax + Environment.NewLine); // SALES_UNIT_PRICE_BEFORE_TAX sb.Append(" ," + entity.sales_cost_price_skip_tax + Environment.NewLine); // SALES_COST_PRICE_SKIP_TAX sb.Append(" ," + entity.sales_cost_price_before_tax + Environment.NewLine); // SALES_COST_PRICE_BEFORE_TAX sb.Append(" ," + entity.purchase_unit_price_skip_tax + Environment.NewLine); // PURCHASE_UNIT_PRICE_SKIP_TAX sb.Append(" ," + entity.purchase_unit_price_before_tax + Environment.NewLine); // PURCHASE_UNIT_PRICE_BEFORE_TAX sb.Append(" ," + ExEscape.zRepStr(entity.group1_id) + Environment.NewLine); // GROUP1_ID sb.Append(" ," + ExEscape.zRepStr(entity.group2_id) + Environment.NewLine); // GROUP2_ID sb.Append(" ," + ExEscape.zRepStr(entity.group3_id) + Environment.NewLine); // GROUP3_ID sb.Append(" ," + ExEscape.zRepStr(entity.memo) + Environment.NewLine); // MEMO sb.Append(" ," + entity.display_division_id + Environment.NewLine); // DISPLAY_FLG sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins, PG_NM, "M_COMMODITY", ExCast.zCInt(personId), _Id, ipAdress, userId)); #endregion #endregion db.ExecuteSQL(sb.ToString(), false); #region Commodity Inventory Insert try { #region Delete SQL sb.Length = 0; sb.Append("DELETE FROM M_COMMODITY_INVENTORY " + Environment.NewLine); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); // ID #endregion db.ExecuteSQL(sb.ToString(), false); #region SQL sb.Length = 0; sb.Append("SELECT MT.* " + Environment.NewLine); sb.Append(" FROM SYS_M_COMPANY_GROUP AS MT" + Environment.NewLine); sb.Append(" WHERE MT.COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" ORDER BY MT.ID " + Environment.NewLine); #endregion dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { #region Insert SQL sb.Length = 0; sb.Append("INSERT INTO M_COMMODITY_INVENTORY " + Environment.NewLine); sb.Append(" ( COMPANY_ID" + Environment.NewLine); sb.Append(" , GROUP_ID" + Environment.NewLine); sb.Append(" , ID" + Environment.NewLine); sb.Append(" , INVENTORY_NUMBER" + Environment.NewLine); sb.Append(" , UPDATE_FLG" + Environment.NewLine); sb.Append(" , DELETE_FLG" + Environment.NewLine); sb.Append(" , CREATE_PG_ID" + Environment.NewLine); sb.Append(" , CREATE_ADRESS" + Environment.NewLine); sb.Append(" , CREATE_USER_ID" + Environment.NewLine); sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine); sb.Append(" , CREATE_DATE" + Environment.NewLine); sb.Append(" , CREATE_TIME" + Environment.NewLine); sb.Append(" , UPDATE_PG_ID" + Environment.NewLine); sb.Append(" , UPDATE_ADRESS" + Environment.NewLine); sb.Append(" , UPDATE_USER_ID" + Environment.NewLine); sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine); sb.Append(" , UPDATE_DATE" + Environment.NewLine); sb.Append(" , UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("SELECT " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" ," + ExCast.zCStr(dt.DefaultView[i]["ID"]) + Environment.NewLine); // GROUP_ID sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); // ID sb.Append(" ,0" + Environment.NewLine); // INVENTORY_NUMBER sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins, PG_NM, "M_COMMODITY_INVENTORY", ExCast.zCInt(personId), _Id, ipAdress, userId)); #endregion db.ExecuteSQL(sb.ToString(), false); } } } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Commodity Inventory Insert)", ex); return(CLASS_NM + ".UpdateCommodity(Commodity Inventory Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Insert)", ex); return(CLASS_NM + ".UpdateCommodity(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Update if (type == 0) { try { #region SQL string _main_purchase_id = entity.main_purchase_id; if (ExCast.IsNumeric(_main_purchase_id)) { _main_purchase_id = ExCast.zCDbl(_main_purchase_id).ToString(); } sb.Length = 0; sb.Append("UPDATE M_COMMODITY " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 0)); sb.Append(" ,NAME = " + ExEscape.zRepStr(entity.name) + Environment.NewLine); sb.Append(" ,KANA = " + ExEscape.zRepStr(entity.kana) + Environment.NewLine); sb.Append(" ,UNIT_ID = " + entity.unit_id + Environment.NewLine); sb.Append(" ,ENTER_NUMBER = " + entity.enter_number + Environment.NewLine); sb.Append(" ,NUMBER_DECIMAL_DIGIT = " + entity.number_decimal_digit + Environment.NewLine); sb.Append(" ,UNIT_DECIMAL_DIGIT = " + entity.unit_decimal_digit + Environment.NewLine); sb.Append(" ,TAXATION_DIVISION_ID = " + entity.taxation_divition_id + Environment.NewLine); sb.Append(" ,INVENTORY_MANAGEMENT_DIVISION_ID = " + entity.inventory_management_division_id + Environment.NewLine); sb.Append(" ,PURCHASE_LOT = " + entity.purchase_lot + Environment.NewLine); sb.Append(" ,LEAD_TIME = " + entity.lead_time + Environment.NewLine); sb.Append(" ,JUST_INVENTORY_NUMBER = " + entity.just_inventory_number + Environment.NewLine); sb.Append(" ,INVENTORY_NUMBER = " + entity.inventory_number + Environment.NewLine); sb.Append(" ,INVENTORY_EVALUATION_ID = " + entity.inventory_evaluation_id + Environment.NewLine); sb.Append(" ,MAIN_PURCHASE_ID = " + ExEscape.zRepStr(_main_purchase_id) + Environment.NewLine); sb.Append(" ,RETAIL_PRICE_SKIP_TAX = " + entity.retail_price_skip_tax + Environment.NewLine); sb.Append(" ,RETAIL_PRICE_BEFORE_TAX = " + entity.retail_price_before_tax + Environment.NewLine); sb.Append(" ,SALES_UNIT_PRICE_SKIP_TAX = " + entity.sales_unit_price_skip_tax + Environment.NewLine); sb.Append(" ,SALES_UNIT_PRICE_BEFORE_TAX = " + entity.sales_unit_price_before_tax + Environment.NewLine); sb.Append(" ,SALES_COST_PRICE_SKIP_TAX = " + entity.sales_cost_price_skip_tax + Environment.NewLine); sb.Append(" ,SALES_COST_PRICE_BEFORE_TAX = " + entity.sales_cost_price_before_tax + Environment.NewLine); sb.Append(" ,PURCHASE_UNIT_PRICE_SKIP_TAX = " + entity.purchase_unit_price_skip_tax + Environment.NewLine); sb.Append(" ,PURCHASE_UNIT_PRICE_BEFORE_TAX = " + entity.purchase_unit_price_before_tax + Environment.NewLine); sb.Append(" ,GROUP1_ID = " + ExEscape.zRepStr(entity.group1_id) + Environment.NewLine); sb.Append(" ,GROUP2_ID = " + ExEscape.zRepStr(entity.group2_id) + Environment.NewLine); sb.Append(" ,GROUP3_ID = " + ExEscape.zRepStr(entity.group3_id) + Environment.NewLine); sb.Append(" ,MEMO = " + ExEscape.zRepStr(entity.memo) + Environment.NewLine); sb.Append(" ,DISPLAY_FLG = " + entity.display_division_id + Environment.NewLine); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Update)", ex); return(CLASS_NM + ".UpdateCommodity(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Delete if (type == 2) { #region Exist Data try { bool _ret = false; _ret = DataExists.IsExistData(db, companyId, groupId, "T_ESTIMATE_D", "COMMODITY_ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String); if (_ret == true) { return("商品ID : " + Id + " は見積データに使用されている為、削除できません。"); } _ret = DataExists.IsExistData(db, companyId, groupId, "T_ORDER_D", "COMMODITY_ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String); if (_ret == true) { return("商品ID : " + Id + " は受注データに使用されている為、削除できません。"); } _ret = DataExists.IsExistData(db, companyId, groupId, "T_SALES_D", "COMMODITY_ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String); if (_ret == true) { return("商品ID : " + Id + " は売上データに使用されている為、削除できません。"); } } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Exist Data)", ex); return(CLASS_NM + ".UpdateCommodity(Exist Data) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Delete Commodity Inventory try { sb.Length = 0; sb.Append("UPDATE M_COMMODITY_INVENTORY " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 1)); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Delete Commodity Inventory)", ex); return(CLASS_NM + ".UpdateCommodity(Commodity Inventory) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Update try { sb.Length = 0; sb.Append("UPDATE M_COMMODITY " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 1)); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Delete)", ex); return(CLASS_NM + ".UpdateCommodity(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion } #endregion #region PG排他制御 if (type == 0 || type == 2) { try { DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(DelLockPg)", ex); return(CLASS_NM + ".UpdateCommodity(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(CommitTransaction)", ex); return(CLASS_NM + ".UpdateCommodity(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(DbClose)", ex); return(CLASS_NM + ".UpdateCommodity(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { switch (type) { case 0: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Update, "ID:" + Id.ToString()); break; case 1: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Insert, "ID:" + _Id.ToString()); break; case 2: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Delete, "ID:" + Id.ToString()); break; default: break; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Add Evidence)", ex); return(CLASS_NM + ".UpdateCommodity(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Return if (type == 1 && (Id == "0" || Id == "")) { return("Auto Insert success : " + "ID : " + _Id.ToString() + "で登録しました。"); } else { return(""); } #endregion }
public string UpdateSupplier(string random, int type, string CustomerId, string Id, EntitySupplier entity) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(認証処理)", ex); return(CLASS_NM + ".UpdateSupplier : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string _Id = ""; #endregion #region Databese Open try { db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR])); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(DbOpen)", ex); return(CLASS_NM + ".UpdateSupplier(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(BeginTransaction)", ex); return(CLASS_NM + ".UpdateSupplier(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Get Max Master ID if (type == 1 && (Id == "" || Id == "0")) { try { DataMasterId.GetMaxMasterId(companyId, ExCast.zNumZeroNothingFormat(CustomerId), db, DataMasterId.geMasterMaxIdKbn.Supplier, out _Id); if (_Id == "") { return("ID取得に失敗しました。"); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(GetMaxMasterId)", ex); return(CLASS_NM + ".UpdateSupplier(GetMaxMasterId) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } else { _Id = Id; } #endregion #region Insert if (type == 1) { try { #region Delete SQL sb.Length = 0; sb.Append("DELETE FROM M_SUPPLIER " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 1 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); sb.Append(" AND CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine); #endregion db.ExecuteSQL(sb.ToString(), false); #region Insert SQL sb.Length = 0; sb.Append("INSERT INTO M_SUPPLIER " + Environment.NewLine); sb.Append(" ( COMPANY_ID" + Environment.NewLine); sb.Append(" , CUSTOMER_ID" + Environment.NewLine); sb.Append(" , ID" + Environment.NewLine); sb.Append(" , ID2" + Environment.NewLine); sb.Append(" , NAME" + Environment.NewLine); sb.Append(" , KANA" + Environment.NewLine); sb.Append(" , ABOUT_NAME" + Environment.NewLine); sb.Append(" , ZIP_CODE" + Environment.NewLine); sb.Append(" , PREFECTURE_ID" + Environment.NewLine); sb.Append(" , CITY_ID" + Environment.NewLine); sb.Append(" , TOWN_ID" + Environment.NewLine); sb.Append(" , ADRESS_CITY" + Environment.NewLine); sb.Append(" , ADRESS_TOWN" + Environment.NewLine); sb.Append(" , ADRESS1" + Environment.NewLine); sb.Append(" , ADRESS2" + Environment.NewLine); sb.Append(" , STATION_NAME" + Environment.NewLine); sb.Append(" , POST_NAME" + Environment.NewLine); sb.Append(" , PERSON_NAME" + Environment.NewLine); sb.Append(" , TITLE_ID" + Environment.NewLine); sb.Append(" , TITLE_NAME" + Environment.NewLine); sb.Append(" , TEL" + Environment.NewLine); sb.Append(" , FAX" + Environment.NewLine); sb.Append(" , MAIL_ADRESS" + Environment.NewLine); sb.Append(" , MOBILE_TEL" + Environment.NewLine); sb.Append(" , MOBILE_ADRESS" + Environment.NewLine); sb.Append(" , URL" + Environment.NewLine); sb.Append(" , DIVIDE_PERMISSION_ID" + Environment.NewLine); sb.Append(" , MEMO" + Environment.NewLine); sb.Append(" , DISPLAY_FLG" + Environment.NewLine); sb.Append(" , UPDATE_FLG" + Environment.NewLine); sb.Append(" , DELETE_FLG" + Environment.NewLine); sb.Append(" , CREATE_PG_ID" + Environment.NewLine); sb.Append(" , CREATE_ADRESS" + Environment.NewLine); sb.Append(" , CREATE_USER_ID" + Environment.NewLine); sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine); sb.Append(" , CREATE_DATE" + Environment.NewLine); sb.Append(" , CREATE_TIME" + Environment.NewLine); sb.Append(" , UPDATE_PG_ID" + Environment.NewLine); sb.Append(" , UPDATE_ADRESS" + Environment.NewLine); sb.Append(" , UPDATE_USER_ID" + Environment.NewLine); sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine); sb.Append(" , UPDATE_DATE" + Environment.NewLine); sb.Append(" , UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("SELECT " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine); // CUSTOMER_ID sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); // ID sb.Append(" ," + ExCast.zIdForNumIndex(_Id) + Environment.NewLine); // ID2 sb.Append(" ," + ExEscape.zRepStr(entity.name) + Environment.NewLine); // NAME sb.Append(" ," + ExEscape.zRepStr(entity.kana) + Environment.NewLine); // KANA sb.Append(" ," + ExEscape.zRepStr(entity.about_name) + Environment.NewLine); // ABOUT_NAME sb.Append(" ," + ExCast.zNullToZero(entity.zip_code_from + entity.zip_code_to) + Environment.NewLine); // ZIP_CODE sb.Append(" ," + entity.prefecture_id + Environment.NewLine); // PREFECTURE_ID sb.Append(" ," + entity.city_id + Environment.NewLine); // CITY_ID sb.Append(" ," + entity.town_id + Environment.NewLine); // TOWN_ID sb.Append(" ," + ExEscape.zRepStr(entity.adress_city) + Environment.NewLine); // ADRESS_CITY sb.Append(" ," + ExEscape.zRepStr(entity.adress_town) + Environment.NewLine); // ADRESS_TOWN sb.Append(" ," + ExEscape.zRepStr(entity.adress1) + Environment.NewLine); // ADRESS1 sb.Append(" ," + ExEscape.zRepStr(entity.adress2) + Environment.NewLine); // ADRESS2 sb.Append(" ," + ExEscape.zRepStr(entity.station_name) + Environment.NewLine); // STATION_NAME sb.Append(" ," + ExEscape.zRepStr(entity.post_name) + Environment.NewLine); // POST_NAME sb.Append(" ," + ExEscape.zRepStr(entity.person_name) + Environment.NewLine); // PERSON_NAME sb.Append(" ," + entity.title_id + Environment.NewLine); // TITLE_ID sb.Append(" ," + ExEscape.zRepStr(entity.title_name) + Environment.NewLine); // TITLE_NAME sb.Append(" ," + ExEscape.zRepStr(entity.tel) + Environment.NewLine); // TEL sb.Append(" ," + ExEscape.zRepStr(entity.fax) + Environment.NewLine); // FAX sb.Append(" ," + ExEscape.zRepStr(entity.mail_adress) + Environment.NewLine); // MAIL_ADRESS sb.Append(" ," + ExEscape.zRepStr(entity.mobile_tel) + Environment.NewLine); // MOBILE_TEL sb.Append(" ," + ExEscape.zRepStr(entity.mobile_adress) + Environment.NewLine); // MOBILE_ADRESS sb.Append(" ," + ExEscape.zRepStr(entity.url) + Environment.NewLine); // URL sb.Append(" ," + entity.divide_permission_id + Environment.NewLine); // DIVIDE_PERMISSION_ID sb.Append(" ," + ExEscape.zRepStr(entity.memo) + Environment.NewLine); // MEMO sb.Append(" ," + entity.display_division_id + Environment.NewLine); // DISPLAY_FLG sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins, PG_NM, "M_SUPPLIER", ExCast.zCInt(personId), _Id, ipAdress, userId)); #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Insert)", ex); return(CLASS_NM + ".UpdateSupplier(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Update if (type == 0) { try { #region SQL sb.Length = 0; sb.Append("UPDATE M_SUPPLIER " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 0)); sb.Append(" ,NAME = " + ExEscape.zRepStr(entity.name) + Environment.NewLine); sb.Append(" ,KANA = " + ExEscape.zRepStr(entity.kana) + Environment.NewLine); sb.Append(" ,ABOUT_NAME = " + ExEscape.zRepStr(entity.about_name) + Environment.NewLine); sb.Append(" ,ZIP_CODE = " + ExCast.zNullToZero(entity.zip_code_from + entity.zip_code_to) + Environment.NewLine); sb.Append(" ,PREFECTURE_ID = " + entity.prefecture_id + Environment.NewLine); sb.Append(" ,CITY_ID = " + entity.city_id + Environment.NewLine); sb.Append(" ,TOWN_ID = " + entity.town_id + Environment.NewLine); sb.Append(" ,ADRESS_CITY = " + ExEscape.zRepStr(entity.adress_city) + Environment.NewLine); sb.Append(" ,ADRESS_TOWN = " + ExEscape.zRepStr(entity.adress_town) + Environment.NewLine); sb.Append(" ,ADRESS1 = " + ExEscape.zRepStr(entity.adress1) + Environment.NewLine); sb.Append(" ,ADRESS2 = " + ExEscape.zRepStr(entity.adress2) + Environment.NewLine); sb.Append(" ,STATION_NAME = " + ExEscape.zRepStr(entity.station_name) + Environment.NewLine); sb.Append(" ,POST_NAME = " + ExEscape.zRepStr(entity.post_name) + Environment.NewLine); sb.Append(" ,PERSON_NAME = " + ExEscape.zRepStr(entity.person_name) + Environment.NewLine); sb.Append(" ,TITLE_ID = " + entity.title_id + Environment.NewLine); sb.Append(" ,TITLE_NAME = " + ExEscape.zRepStr(entity.title_name) + Environment.NewLine); sb.Append(" ,TEL = " + ExEscape.zRepStr(entity.tel) + Environment.NewLine); sb.Append(" ,FAX = " + ExEscape.zRepStr(entity.fax) + Environment.NewLine); sb.Append(" ,MAIL_ADRESS = " + ExEscape.zRepStr(entity.mail_adress) + Environment.NewLine); sb.Append(" ,MOBILE_TEL = " + ExEscape.zRepStr(entity.mobile_tel) + Environment.NewLine); sb.Append(" ,MOBILE_ADRESS = " + ExEscape.zRepStr(entity.mobile_adress) + Environment.NewLine); sb.Append(" ,URL = " + ExEscape.zRepStr(entity.url) + Environment.NewLine); sb.Append(" ,DIVIDE_PERMISSION_ID = " + entity.divide_permission_id + Environment.NewLine); sb.Append(" ,MEMO = " + ExEscape.zRepStr(entity.memo) + Environment.NewLine); sb.Append(" ,DISPLAY_FLG = " + entity.display_division_id + Environment.NewLine); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID sb.Append(" AND CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine); #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Update)", ex); return(CLASS_NM + ".UpdateSupplier(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Delete if (type == 2) { #region Exist Data try { bool _ret = false; _ret = DataExists.IsExistDataDouble(db, companyId, "", "T_ESTIMATE_H", "SUPPLIER_ID", ExCast.zNumZeroNothingFormat(Id), "CUSTOMER_ID", ExCast.zNumZeroNothingFormat(CustomerId), CommonUtl.geStrOrNumKbn.String); if (_ret == true) { return("ID : " + Id + " は見積データの納入先に使用されている為、削除できません。"); } _ret = DataExists.IsExistDataDouble(db, companyId, "", "T_ORDER_H", "SUPPLIER_ID", ExCast.zNumZeroNothingFormat(Id), "CUSTOMER_ID", ExCast.zNumZeroNothingFormat(CustomerId), CommonUtl.geStrOrNumKbn.String); if (_ret == true) { return("ID : " + Id + " は受注データの納入先に使用されている為、削除できません。"); } _ret = DataExists.IsExistDataDouble(db, companyId, "", "T_SALES_H", "SUPPLIER_ID", ExCast.zNumZeroNothingFormat(Id), "CUSTOMER_ID", ExCast.zNumZeroNothingFormat(CustomerId), CommonUtl.geStrOrNumKbn.String); if (_ret == true) { return("ID : " + Id + " は売上データの納入先に使用されている為、削除できません。"); } } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Exist Data)", ex); return(CLASS_NM + ".UpdateSupplier(Exist Data) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Update try { sb.Length = 0; sb.Append("UPDATE M_SUPPLIER " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 1)); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID sb.Append(" AND CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine); db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Delete)", ex); return(CLASS_NM + ".UpdateSupplier(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion } #endregion #region PG排他制御 if (type == 0 || type == 2) { try { DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(DelLockPg)", ex); return(CLASS_NM + ".UpdateSupplier(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(CommitTransaction)", ex); return(CLASS_NM + ".UpdateSupplier(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(DbClose)", ex); return(CLASS_NM + ".UpdateSupplier(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { switch (type) { case 0: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Update, "ID:" + Id.ToString()); break; case 1: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Insert, "ID:" + _Id.ToString()); break; case 2: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Delete, "ID:" + Id.ToString()); break; default: break; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Add Evidence)", ex); return(CLASS_NM + ".UpdateSupplier(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Return if (type == 1 && (Id == "0" || Id == "")) { return("Auto Insert success : " + "ID : " + _Id.ToString() + "で登録しました。"); } else { return(""); } #endregion }
public string UpdateInquiry(string random, int type, long no, EntityInquiry entity) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(認証処理)", ex); return(CLASS_NM + ".UpdateInquiry : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData sys_db = null; ExMySQLData db = null; string _no = ""; DateTime now = DateTime.Now; string date = now.ToString("yyyy/MM/dd"); string time = now.ToString("HH:mm:ss"); #endregion #region Databese Open try { sys_db = new ExMySQLData(); sys_db.DbOpen(); db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR])); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(DbOpen)", ex); return(CLASS_NM + ".UpdateInquiry(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { sys_db.ExBeginTransaction(); if (CommonUtl.gSysDbKbn == 0) { db.ExBeginTransaction(); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(BeginTransaction)", ex); return(CLASS_NM + ".UpdateInquiry(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Get Max ID if (type == 1) { try { DataMaxId.GetMaxId(sys_db, "SYS_T_INQUIRY_H", "NO", out _no); if (_no == "") { return("サポートNOの取得に失敗しました。"); } } catch (Exception ex) { sys_db.ExRollbackTransaction(); if (CommonUtl.gSysDbKbn == 0) { db.ExRollbackTransaction(); } CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(GetMaxId)", ex); return(CLASS_NM + ".UpdateInquiry(GetMaxId) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } else { _no = no.ToString(); } #endregion #region Insert if (type == 1) { try { #region Insert SQL sb.Length = 0; sb.Append("INSERT INTO SYS_T_INQUIRY_H " + Environment.NewLine); sb.Append(" ( NO" + Environment.NewLine); sb.Append(" , COMPANY_ID" + Environment.NewLine); sb.Append(" , GROUP_ID" + Environment.NewLine); sb.Append(" , PERSON_ID" + Environment.NewLine); sb.Append(" , DATE" + Environment.NewLine); sb.Append(" , TIME" + Environment.NewLine); sb.Append(" , TITLE" + Environment.NewLine); sb.Append(" , INQUIRY_DIVISION_ID" + Environment.NewLine); sb.Append(" , INQUIRY_LEVEL_ID" + Environment.NewLine); sb.Append(" , INQUIRY_STATE_ID" + Environment.NewLine); sb.Append(" , MEMO" + Environment.NewLine); sb.Append(" , UPDATE_FLG" + Environment.NewLine); sb.Append(" , DELETE_FLG" + Environment.NewLine); sb.Append(" , CREATE_PG_ID" + Environment.NewLine); sb.Append(" , CREATE_ADRESS" + Environment.NewLine); sb.Append(" , CREATE_USER_ID" + Environment.NewLine); sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine); sb.Append(" , CREATE_DATE" + Environment.NewLine); sb.Append(" , CREATE_TIME" + Environment.NewLine); sb.Append(" , UPDATE_PG_ID" + Environment.NewLine); sb.Append(" , UPDATE_ADRESS" + Environment.NewLine); sb.Append(" , UPDATE_USER_ID" + Environment.NewLine); sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine); sb.Append(" , UPDATE_DATE" + Environment.NewLine); sb.Append(" , UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("SELECT " + _no + Environment.NewLine); // NO sb.Append(" ," + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" ," + groupId + Environment.NewLine); // GROUP_ID sb.Append(" ," + entity.person_id + Environment.NewLine); // PERSON_ID sb.Append(" ," + ExEscape.zRepStr(date) + Environment.NewLine); // DATE sb.Append(" ," + ExEscape.zRepStr(time) + Environment.NewLine); // TIME sb.Append(" ," + ExEscape.zRepStr(entity.title) + Environment.NewLine); // TITLE sb.Append(" ," + entity.inquiry_division_id + Environment.NewLine); // INQUIRY_DIVISION_ID sb.Append(" ," + entity.inquiry_level_id + Environment.NewLine); // INQUIRY_LEVEL_ID sb.Append(" ," + entity.inquiry_level_state_id + Environment.NewLine); // INQUIRY_STATE_ID sb.Append(" ," + ExEscape.zRepStr(entity.memo) + Environment.NewLine); // MEMO sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins, PG_NM, "SYS_T_INQUIRY_H", ExCast.zCInt(personId), _no, ipAdress, userId)); #endregion sys_db.ExecuteSQL(sb.ToString(), false); if (CommonUtl.gSysDbKbn == 0) { db.ExecuteSQL(sb.ToString(), false); } } catch (Exception ex) { sys_db.ExRollbackTransaction(); if (CommonUtl.gSysDbKbn == 0) { db.ExRollbackTransaction(); } CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(Insert)", ex); return(CLASS_NM + ".UpdateInquiry(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Update if (type == 0) { #region Update Head try { #region SQL sb.Length = 0; sb.Append("UPDATE SYS_T_INQUIRY_H " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 0)); sb.Append(" ,INQUIRY_STATE_ID = " + entity.inquiry_level_state_id + Environment.NewLine); sb.Append(" WHERE NO = " + _no + Environment.NewLine); #endregion sys_db.ExecuteSQL(sb.ToString(), false); if (CommonUtl.gSysDbKbn == 0) { db.ExecuteSQL(sb.ToString(), false); } } catch (Exception ex) { sys_db.ExRollbackTransaction(); if (CommonUtl.gSysDbKbn == 0) { db.ExRollbackTransaction(); } CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(Update Head)", ex); return(CLASS_NM + ".UpdateInquiry(Update Head) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion } #endregion #region Update Or Insert(Detail) if (type <= 1) { try { #region Upload File Set if (!string.IsNullOrEmpty(entity.upload_file_path1)) { if (System.IO.Directory.Exists(CommonUtl.gstrFileUpLoadDir + entity.upload_file_path1) && !System.IO.Directory.Exists(CommonUtl.gstrFileUpLoadDir + _no + "-" + entity.rec_no.ToString())) { System.IO.Directory.Move(CommonUtl.gstrFileUpLoadDir + entity.upload_file_path1, CommonUtl.gstrFileUpLoadDir + _no + "-" + entity.rec_no.ToString()); entity.upload_file_path1 = CommonUtl.gstrFileUpLoadDir + _no + "-" + entity.rec_no.ToString(); } } #endregion #region Insert SQL sb.Length = 0; sb.Append("INSERT INTO SYS_T_INQUIRY_D " + Environment.NewLine); sb.Append(" ( NO" + Environment.NewLine); sb.Append(" , REC_NO" + Environment.NewLine); sb.Append(" , DATE" + Environment.NewLine); sb.Append(" , TIME" + Environment.NewLine); sb.Append(" , KBN" + Environment.NewLine); sb.Append(" , PERSON_ID" + Environment.NewLine); sb.Append(" , SUPPORT_PERSON_NAME" + Environment.NewLine); sb.Append(" , UPLOAD_FILE_PATH1" + Environment.NewLine); sb.Append(" , UPLOAD_FILE_PATH2" + Environment.NewLine); sb.Append(" , UPLOAD_FILE_PATH3" + Environment.NewLine); sb.Append(" , UPLOAD_FILE_PATH4" + Environment.NewLine); sb.Append(" , UPLOAD_FILE_PATH5" + Environment.NewLine); sb.Append(" , CONTENT" + Environment.NewLine); sb.Append(" , MEMO" + Environment.NewLine); sb.Append(" , UPDATE_FLG" + Environment.NewLine); sb.Append(" , DELETE_FLG" + Environment.NewLine); sb.Append(" , CREATE_PG_ID" + Environment.NewLine); sb.Append(" , CREATE_ADRESS" + Environment.NewLine); sb.Append(" , CREATE_USER_ID" + Environment.NewLine); sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine); sb.Append(" , CREATE_DATE" + Environment.NewLine); sb.Append(" , CREATE_TIME" + Environment.NewLine); sb.Append(" , UPDATE_PG_ID" + Environment.NewLine); sb.Append(" , UPDATE_ADRESS" + Environment.NewLine); sb.Append(" , UPDATE_USER_ID" + Environment.NewLine); sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine); sb.Append(" , UPDATE_DATE" + Environment.NewLine); sb.Append(" , UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("SELECT " + _no + Environment.NewLine); // NO sb.Append(" ," + entity.rec_no + Environment.NewLine); // REC_NO sb.Append(" ," + ExEscape.zRepStr(date) + Environment.NewLine); // DATE sb.Append(" ," + ExEscape.zRepStr(time) + Environment.NewLine); // TIME sb.Append(" ," + entity.kbn + Environment.NewLine); // KBN sb.Append(" ," + entity.d_person_id + Environment.NewLine); // PERSON_ID sb.Append(" ," + ExEscape.zRepStr(entity.support_person_nm) + Environment.NewLine); // SUPPORT_PERSON_NAME sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path1) + Environment.NewLine); // UPLOAD_FILE_PATH1 sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path2) + Environment.NewLine); // UPLOAD_FILE_PATH2 sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path3) + Environment.NewLine); // UPLOAD_FILE_PATH3 sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path4) + Environment.NewLine); // UPLOAD_FILE_PATH4 sb.Append(" ," + ExEscape.zRepStr(entity.upload_file_path5) + Environment.NewLine); // UPLOAD_FILE_PATH5 sb.Append(" ," + ExEscape.zRepStr(entity.content) + Environment.NewLine); // CONTENT sb.Append(" ," + ExEscape.zRepStr(entity.memo) + Environment.NewLine); // MEMO sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins, PG_NM, "SYS_T_INQUIRY_D", ExCast.zCInt(personId), _no, ipAdress, userId)); #endregion sys_db.ExecuteSQL(sb.ToString(), false); if (CommonUtl.gSysDbKbn == 0) { db.ExecuteSQL(sb.ToString(), false); } } catch (Exception ex) { if (CommonUtl.gSysDbKbn == 0) { db.ExRollbackTransaction(); } sys_db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(Insert Detail)", ex); return(CLASS_NM + ".UpdateInquiry(Insert Detail) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Delete if (type == 2) { } #endregion #region PG排他制御 if (type == 0 || type == 2) { try { DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); } catch (Exception ex) { if (CommonUtl.gSysDbKbn == 0) { db.ExRollbackTransaction(); } sys_db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(DelLockPg)", ex); return(CLASS_NM + ".UpdateInquiry(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region CommitTransaction try { sys_db.ExCommitTransaction(); if (CommonUtl.gSysDbKbn == 0) { db.ExCommitTransaction(); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(CommitTransaction)", ex); return(CLASS_NM + ".UpdateInquiry(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { sys_db.DbClose(); db.DbClose(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(DbClose)", ex); return(CLASS_NM + ".UpdateInquiry(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { sys_db = null; } #endregion #region Add Evidence try { switch (type) { case 0: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Update, "NO:" + _no); break; case 1: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Insert, "NO:" + _no); break; case 2: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Delete, "NO:" + _no); break; default: break; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInquiry(Add Evidence)", ex); return(CLASS_NM + ".UpdateInquiry(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Return if (type == 1) { //return "Auto Insert success : " + "ID : " + _Id.ToString() + "で登録しました。"; return(""); } else { return(""); } #endregion }
public List <EntityAuthority> GetAuthority(string random, int _user_id) { EntityAuthority entity; List <EntityAuthority> entityList = new List <EntityAuthority>(); #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { entity = new EntityAuthority(); entity.MESSAGE = _message; entityList.Add(entity); return(entityList); } } catch (Exception ex) { CommonUtl.ExLogger.Error(Authority_NM + ".GetAuthority(認証処理)", ex); entity = new EntityAuthority(); entity.MESSAGE = Authority_NM + ".GetAuthority : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();; entityList.Add(entity); return(entityList); } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); #region SQL sb.Append("SELECT IFNULL(AR.USER_ID, " + _user_id.ToString() + ") AS USER_ID" + Environment.NewLine); sb.Append(" ,MT.ID AS PG_ID " + Environment.NewLine); sb.Append(" ,IFNULL(AR.AUTHORITY_KBN, 0) AS AUTHORITY_KBN" + Environment.NewLine); sb.Append(" ,IFNULL(AR.MEMO, '') AS MEMO" + Environment.NewLine); sb.Append(" ,IFNULL(AR.DISPLAY_INDEX, 0) AS DISPLAY_INDEX" + Environment.NewLine); sb.Append(" FROM SYS_M_PG AS MT" + Environment.NewLine); #region Join sb.Append(" LEFT JOIN M_AUTHORITY AS AR" + Environment.NewLine); sb.Append(" ON AR.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND AR.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND AR.USER_ID = " + _user_id + Environment.NewLine); sb.Append(" AND AR.PG_ID = MT.ID " + Environment.NewLine); #endregion sb.Append(" WHERE MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.DISPLAY_FLG = 1 " + Environment.NewLine); #endregion dt = db.GetDataTable(sb.ToString()); // 排他制御 DataPgLock.geLovkFlg lockFlg; string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, _user_id.ToString(), ipAdress, db, out lockFlg); if (strErr != "") { entity = new EntityAuthority(); entity.MESSAGE = Authority_NM + ".GetAuthority : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr; entityList.Add(entity); return(entityList); } if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { #region Set Entity entity = new EntityAuthority(); entity.user_id = ExCast.zCInt(dt.DefaultView[i]["USER_ID"]); entity.pg_id = ExCast.zCStr(dt.DefaultView[i]["PG_ID"]); entity.authority_kbn = ExCast.zCInt(dt.DefaultView[i]["AUTHORITY_KBN"]); entity.display_index = ExCast.zCInt(dt.DefaultView[i]["DISPLAY_INDEX"]); entity.memo = ExCast.zCStr(dt.DefaultView[i]["MEMO"]); entity.lock_flg = (int)lockFlg; if (entity.pg_id == "ReportTotal" && _user_id == ExCast.zCInt(userId)) { HttpContext.Current.Session[ExSession.REPORT_TOTAL_AUTHORITY_KBN] = entity.authority_kbn; } entityList.Add(entity); #endregion } } } catch (Exception ex) { CommonUtl.ExLogger.Error(Authority_NM + ".GetAuthority", ex); entityList.Clear(); entity = new EntityAuthority(); entity.MESSAGE = Authority_NM + ".GetAuthority : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); entityList.Add(entity); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Select, ""); return(entityList); }
public EntityUser GetUser(string random, int Id) { EntityUser entity = null; #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { entity = new EntityUser(); entity.MESSAGE = _message; return(entity); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetUserList(認証処理)", ex); entity = new EntityUser(); entity.MESSAGE = "認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();; return(entity); } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); #region SQL sb.Append("SELECT MT.* " + Environment.NewLine); sb.Append(" ,NM.DESCRIPTION AS DISPLAY_DIVISION_NAME " + Environment.NewLine); sb.Append(" ,SG.NAME AS GROUP_NAME " + Environment.NewLine); sb.Append(" ,PS.NAME AS PERSON_NAME " + Environment.NewLine); sb.Append(" FROM SYS_M_USER AS MT" + Environment.NewLine); // 表示区分 sb.Append(" LEFT JOIN SYS_M_NAME AS NM" + Environment.NewLine); sb.Append(" ON NM.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM.DIVISION_ID = " + (int)CommonUtl.geNameKbn.DISPLAY_DIVISION_ID + Environment.NewLine); sb.Append(" AND MT.DISPLAY_FLG = NM.ID" + Environment.NewLine); // グループ sb.Append(" LEFT JOIN SYS_M_COMPANY_GROUP AS SG" + Environment.NewLine); sb.Append(" ON SG.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND SG.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND SG.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine); sb.Append(" AND SG.ID = MT.GROUP_ID" + Environment.NewLine); // 担当 sb.Append(" LEFT JOIN M_PERSON AS PS" + Environment.NewLine); sb.Append(" ON PS.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND PS.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND PS.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine); sb.Append(" AND PS.ID = MT.PERSON_ID" + Environment.NewLine); sb.Append(" WHERE MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.ID = " + Id.ToString() + Environment.NewLine); sb.Append(" ORDER BY MT.COMPANY_ID " + Environment.NewLine); sb.Append(" ,MT.ID " + Environment.NewLine); #endregion dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { entity = new EntityUser(); // 排他制御 DataPgLock.geLovkFlg lockFlg; string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, Id.ToString(), ipAdress, db, out lockFlg); if (strErr != "") { entity.MESSAGE = CLASS_NM + ".GetUser : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr; } #region Set Entity entity.id = ExCast.zCInt(dt.DefaultView[0]["ID"]); entity.company_id = ExCast.zCInt(dt.DefaultView[0]["COMPANY_ID"]); entity.group_id = ExCast.zCInt(dt.DefaultView[0]["GROUP_ID"]); entity.group_nm = ExCast.zCStr(dt.DefaultView[0]["GROUP_NAME"]); entity.login_id = ExCast.zCStr(dt.DefaultView[0]["LOGIN_ID"]); entity.after_login_id = ExCast.zCStr(dt.DefaultView[0]["LOGIN_ID"]); entity.name = ExCast.zCStr(dt.DefaultView[0]["NAME"]); entity.login_password = ExCast.zCStr(dt.DefaultView[0]["PASSWORD"]); entity.person_id = ExCast.zCInt(dt.DefaultView[0]["PERSON_ID"]); entity.person_nm = ExCast.zCStr(dt.DefaultView[0]["PERSON_NAME"]); entity.memo = ExCast.zCStr(dt.DefaultView[0]["MEMO"]); entity.display_division_id = ExCast.zCInt(dt.DefaultView[0]["DISPLAY_FLG"]); entity.display_division_nm = ExCast.zCStr(dt.DefaultView[0]["DISPLAY_DIVISION_NAME"]); entity.lock_flg = (int)lockFlg; #endregion } else { entity = null; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetUser", ex); entity = new EntityUser(); entity.MESSAGE = CLASS_NM + ".GetUser : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Select, "ID:" + Id.ToString()); return(entity); }
public string UpdatePerson(string random, int type, long Id, EntityPerson entity) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(認証処理)", ex); return(CLASS_NM + ".UpdatePerson : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string _Id = ""; #endregion #region Databese Open try { db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR])); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(DbOpen)", ex); return(CLASS_NM + ".UpdatePerson(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(BeginTransaction)", ex); return(CLASS_NM + ".UpdatePerson(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Get Max Master ID if (type == 1 && Id == 0) { try { DataMasterId.GetMaxMasterId(companyId, "", db, DataMasterId.geMasterMaxIdKbn.Person, out _Id); if (_Id == "") { return("ID取得に失敗しました。"); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(GetMaxMasterId)", ex); return(CLASS_NM + ".UpdatePerson(GetMaxMasterId) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } else { _Id = Id.ToString(); } #endregion #region Insert if (type == 1) { try { #region Delete SQL sb.Length = 0; sb.Append("DELETE FROM M_PERSON " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 1 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND ID = " + _Id.ToString() + Environment.NewLine); #endregion db.ExecuteSQL(sb.ToString(), false); #region Insert SQL sb.Length = 0; sb.Append("INSERT INTO M_PERSON " + Environment.NewLine); sb.Append(" ( COMPANY_ID" + Environment.NewLine); sb.Append(" , ID" + Environment.NewLine); sb.Append(" , GROUP_ID" + Environment.NewLine); sb.Append(" , NAME" + Environment.NewLine); sb.Append(" , MEMO" + Environment.NewLine); sb.Append(" , DISPLAY_FLG" + Environment.NewLine); sb.Append(" , UPDATE_FLG" + Environment.NewLine); sb.Append(" , DELETE_FLG" + Environment.NewLine); sb.Append(" , CREATE_PG_ID" + Environment.NewLine); sb.Append(" , CREATE_ADRESS" + Environment.NewLine); sb.Append(" , CREATE_USER_ID" + Environment.NewLine); sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine); sb.Append(" , CREATE_DATE" + Environment.NewLine); sb.Append(" , CREATE_TIME" + Environment.NewLine); sb.Append(" , UPDATE_PG_ID" + Environment.NewLine); sb.Append(" , UPDATE_ADRESS" + Environment.NewLine); sb.Append(" , UPDATE_USER_ID" + Environment.NewLine); sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine); sb.Append(" , UPDATE_DATE" + Environment.NewLine); sb.Append(" , UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("SELECT " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" ," + _Id.ToString() + Environment.NewLine); // ID sb.Append(" ," + entity.group_id + Environment.NewLine); // GROUP_ID sb.Append(" ," + ExEscape.zRepStr(entity.name) + Environment.NewLine); // NAME sb.Append(" ," + ExEscape.zRepStr(entity.memo) + Environment.NewLine); // MEMO sb.Append(" ," + entity.display_division_id + Environment.NewLine); // DISPLAY_FLG sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins, PG_NM, "M_PERSON", ExCast.zCInt(personId), _Id, ipAdress, userId)); #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(Insert)", ex); return(CLASS_NM + ".UpdatePerson(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Update if (type == 0) { try { #region SQL sb.Length = 0; sb.Append("UPDATE M_PERSON " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 0)); sb.Append(" ,GROUP_ID = " + entity.group_id + Environment.NewLine); sb.Append(" ,NAME = " + ExEscape.zRepStr(entity.name) + Environment.NewLine); sb.Append(" ,MEMO = " + ExEscape.zRepStr(entity.memo) + Environment.NewLine); sb.Append(" ,DISPLAY_FLG = " + entity.display_division_id + Environment.NewLine); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" AND ID = " + Id.ToString() + Environment.NewLine); // ID #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(Update)", ex); return(CLASS_NM + ".UpdatePerson(Update) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Delete if (type == 2) { #region Exist Data try { bool _ret = false; _ret = DataExists.IsExistData(db, companyId, groupId, "T_ESTIMATE_H", "PERSON_ID", Id.ToString(), CommonUtl.geStrOrNumKbn.Number); if (_ret == true) { return("担当ID : " + string.Format("{0:000}", Id) + " は見積データの入力担当者に使用されている為、削除できません。"); } _ret = DataExists.IsExistData(db, companyId, groupId, "T_ORDER_H", "PERSON_ID", Id.ToString(), CommonUtl.geStrOrNumKbn.Number); if (_ret == true) { return("担当ID : " + string.Format("{0:000}", Id) + " は受注データの入力担当者に使用されている為、削除できません。"); } _ret = DataExists.IsExistData(db, companyId, groupId, "T_SALES_H", "PERSON_ID", Id.ToString(), CommonUtl.geStrOrNumKbn.Number); if (_ret == true) { return("担当ID : " + string.Format("{0:000}", Id) + " は売上データの入力担当者に使用されている為、削除できません。"); } _ret = DataExists.IsExistData(db, companyId, groupId, "T_RECEIPT_H", "PERSON_ID", Id.ToString(), CommonUtl.geStrOrNumKbn.Number); if (_ret == true) { return("担当ID : " + string.Format("{0:000}", Id) + " は入金データの入力担当者に使用されている為、削除できません。"); } } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(Exist Data)", ex); return(CLASS_NM + ".UpdatePerson(Exist Data) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Update try { sb.Length = 0; sb.Append("UPDATE M_PERSON " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 1)); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" AND ID = " + Id.ToString() + Environment.NewLine); // ID db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(Delete)", ex); return(CLASS_NM + ".UpdatePerson(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion } #endregion #region PG排他制御 if (type == 0 || type == 2) { try { DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(DelLockPg)", ex); return(CLASS_NM + ".UpdatePerson(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(CommitTransaction)", ex); return(CLASS_NM + ".UpdatePerson(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(DbClose)", ex); return(CLASS_NM + ".UpdatePerson(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { switch (type) { case 0: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Update, "ID:" + Id.ToString()); break; case 1: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Insert, "ID:" + _Id.ToString()); break; case 2: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Delete, "ID:" + Id.ToString()); break; default: break; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePerson(Add Evidence)", ex); return(CLASS_NM + ".UpdatePerson(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Return if (type == 1 && Id == 0) { return("Auto Insert success : " + "ID : " + _Id.ToString() + "で登録しました。"); } else { return(""); } #endregion }
public string UpdateUser(string random, int type, long Id, EntityUser entity) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(認証処理)", ex); return(CLASS_NM + ".UpdateUser : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string _Id = ""; _Id = Id.ToString(); #endregion #region Databese Open try { db = new ExMySQLData(); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(DbOpen)", ex); return(CLASS_NM + ".UpdateUser(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(BeginTransaction)", ex); return(CLASS_NM + ".UpdateUser(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Update if (type == 0) { try { #region SQL sb.Length = 0; sb.Append("UPDATE SYS_M_USER " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 0)); sb.Append(" ,GROUP_ID = " + entity.group_id + Environment.NewLine); sb.Append(" ,LOGIN_ID = " + ExEscape.zRepStr(entity.after_login_id) + Environment.NewLine); sb.Append(" ,NAME = " + ExEscape.zRepStr(entity.name) + Environment.NewLine); sb.Append(" ,PASSWORD = "******" ,PERSON_ID = " + entity.person_id + Environment.NewLine); sb.Append(" ,MEMO = " + ExEscape.zRepStr(entity.memo) + Environment.NewLine); sb.Append(" ,DISPLAY_FLG = 1" + Environment.NewLine); sb.Append(" WHERE ID = " + Id.ToString() + Environment.NewLine); // ID #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(Update)", ex); return(CLASS_NM + ".UpdateUser(Update) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Delete if (type == 2) { //#region Exist Data //try //{ // bool _ret = false; // _ret = DataExists.IsExistData(db, companyId, "", "T_ORDER_H", "User_ID", Id.ToString(), CommonUtl.geStrOrNumKbn.Number); // if (_ret == true) // { // return "担当ID : " + Id + " は受注データの入力担当者に使用されている為、削除できません。"; // } //} //catch (Exception ex) //{ // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(Exist Data)", ex); // return CLASS_NM + ".UpdateUser(Exist Data) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; //} //#endregion //#region Update //try //{ // sb.Length = 0; // sb.Append("UPDATE SYS_M_USER " + Environment.NewLine); // sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, // ExCast.zCInt(personId), // ipAdress, // userId, // 1)); // sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID // sb.Append(" AND ID = " + Id.ToString() + Environment.NewLine); // ID // db.ExecuteSQL(sb.ToString(), false); //} //catch (Exception ex) //{ // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(Delete)", ex); // return CLASS_NM + ".UpdateUser(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; //} //#endregion } #endregion #region PG排他制御 if (type == 0 || type == 2) { try { DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(DelLockPg)", ex); return(CLASS_NM + ".UpdateUser(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(CommitTransaction)", ex); return(CLASS_NM + ".UpdateUser(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(DbClose)", ex); return(CLASS_NM + ".UpdateUser(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { switch (type) { case 0: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Update, "ID:" + Id.ToString()); break; case 1: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Insert, "ID:" + _Id.ToString()); break; case 2: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Delete, "ID:" + Id.ToString()); break; default: break; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateUser(Add Evidence)", ex); return(CLASS_NM + ".UpdateUser(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Return if (type == 1 && Id == 0) { return("Auto Insert success : " + "ID : " + _Id.ToString() + "で登録しました。"); } else { return(""); } #endregion }
protected void Page_Load(object sender, EventArgs e) { string errMsg = ""; #region Parameter Get string rptKbn = ""; string pgId = ""; string random = ""; string _prm = ""; string[] prm; string downLoadFileName = ""; string downLoadFilePath = ""; try { rptKbn = Request.QueryString["rptKbn"]; pgId = Request.QueryString["pgId"]; random = Request.QueryString["random"]; downLoadFileName = Request.QueryString["downLoadFileName"]; downLoadFilePath = Request.QueryString["downLoadFilePath"]; downLoadFilePath = downLoadFilePath.Replace("@AAB@", @"\").Replace("@AAD@", "/"); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Parameter Get)", ex); errMsg = CLASS_NM + ".Page_Load(Parameter Get) : 予期せぬエラーが発生しました" + Environment.NewLine + ex.Message; } #endregion #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; if (string.IsNullOrEmpty(errMsg)) { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(認証処理) : 認証に失敗しました。" + Environment.NewLine + _message); return; } } #endregion #region Response try { if (errMsg != "") { Response.ContentType = "application/octet-stream"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + downLoadFileName); Response.Flush(); string ret_errMsg = "error message start ==>" + errMsg; if (ExCast.LenB(ret_errMsg) < 200) { ret_errMsg += Microsoft.VisualBasic.Strings.Space(201 - ExCast.LenB(ret_errMsg)); } Response.Write(ret_errMsg); Response.Flush(); Response.Close(); } else { Response.ContentType = "application/octet-stream"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + downLoadFileName); Response.TransmitFile(downLoadFilePath); Response.Flush(); Response.Close(); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Response)", ex); } #endregion }
public EntitySupplier GetSupplier(string random, string CustomerId, string Id) { EntitySupplier entity; #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { entity = new EntitySupplier(); entity.MESSAGE = _message; return(entity); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetSupplier(認証処理)", ex); entity = new EntitySupplier(); entity.MESSAGE = CLASS_NM + ".GetSupplier : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();; return(entity); } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); #region SQL sb.Append("SELECT MT.* " + Environment.NewLine); sb.Append(" ,CM.NAME AS CUSTOMER_NAME " + Environment.NewLine); sb.Append(" ,NM1.DESCRIPTION AS DIVIDE_PERMISSION_NAME " + Environment.NewLine); sb.Append(" ,NM.DESCRIPTION AS DISPLAY_DIVISION_NAME " + Environment.NewLine); sb.Append(" FROM M_SUPPLIER AS MT" + Environment.NewLine); #region Join // 得意先 sb.Append(" LEFT JOIN M_CUSTOMER AS CM" + Environment.NewLine); sb.Append(" ON CM.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND CM.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND CM.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine); sb.Append(" AND CM.ID = MT.CUSTOMER_ID" + Environment.NewLine); // 分納許可 sb.Append(" LEFT JOIN SYS_M_NAME AS NM1" + Environment.NewLine); sb.Append(" ON NM1.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM1.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM1.DIVISION_ID = " + (int)CommonUtl.geNameKbn.DIVIDE_PERMISSION_ID + Environment.NewLine); sb.Append(" AND NM1.ID = MT.DIVIDE_PERMISSION_ID" + Environment.NewLine); // 表示区分 sb.Append(" LEFT JOIN SYS_M_NAME AS NM" + Environment.NewLine); sb.Append(" ON NM.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM.DIVISION_ID = " + (int)CommonUtl.geNameKbn.DISPLAY_DIVISION_ID + Environment.NewLine); sb.Append(" AND NM.ID = MT.DISPLAY_FLG" + Environment.NewLine); #endregion sb.Append(" WHERE MT.COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine); sb.Append(" AND MT.ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); sb.Append(" ORDER BY MT.COMPANY_ID " + Environment.NewLine); sb.Append(" ,MT.ID " + Environment.NewLine); #endregion dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { entity = new EntitySupplier(); // 排他制御 DataPgLock.geLovkFlg lockFlg; string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, ExCast.zNumZeroNothingFormat(CustomerId) + "-" + ExCast.zNumZeroNothingFormat(Id), ipAdress, db, out lockFlg); if (strErr != "") { entity.MESSAGE = CLASS_NM + ".GetSupplier : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr; } #region Set Entity entity.id = ExCast.zCStr(dt.DefaultView[0]["ID"]); entity.name = ExCast.zCStr(dt.DefaultView[0]["NAME"]); entity.kana = ExCast.zCStr(dt.DefaultView[0]["KANA"]); entity.about_name = ExCast.zCStr(dt.DefaultView[0]["ABOUT_NAME"]); string _zip = ExCast.zCStr(dt.DefaultView[0]["ZIP_CODE"]); if (!string.IsNullOrEmpty(_zip) && ExCast.zCStr(_zip) != "0") { _zip = string.Format("{0:0000000}", ExCast.zCDbl(_zip)); entity.zip_code_from = _zip.Substring(0, 3); entity.zip_code_to = _zip.Substring(3, 4); } else { entity.zip_code_from = ""; entity.zip_code_to = ""; } entity.prefecture_id = ExCast.zCInt(dt.DefaultView[0]["PREFECTURE_ID"]); entity.city_id = ExCast.zCInt(dt.DefaultView[0]["CITY_ID"]); entity.town_id = ExCast.zCInt(dt.DefaultView[0]["TOWN_ID"]); entity.adress_city = ExCast.zCStr(dt.DefaultView[0]["ADRESS_CITY"]); entity.adress_town = ExCast.zCStr(dt.DefaultView[0]["ADRESS_TOWN"]); entity.adress1 = ExCast.zCStr(dt.DefaultView[0]["ADRESS1"]); entity.adress2 = ExCast.zCStr(dt.DefaultView[0]["ADRESS2"]); entity.station_name = ExCast.zCStr(dt.DefaultView[0]["STATION_NAME"]); entity.post_name = ExCast.zCStr(dt.DefaultView[0]["POST_NAME"]); entity.person_name = ExCast.zCStr(dt.DefaultView[0]["PERSON_NAME"]); entity.title_id = ExCast.zCInt(dt.DefaultView[0]["TITLE_ID"]); entity.title_name = ExCast.zCStr(dt.DefaultView[0]["TITLE_NAME"]); entity.tel = ExCast.zCStr(dt.DefaultView[0]["TEL"]); entity.fax = ExCast.zCStr(dt.DefaultView[0]["FAX"]); entity.mail_adress = ExCast.zCStr(dt.DefaultView[0]["MAIL_ADRESS"]); entity.mobile_tel = ExCast.zCStr(dt.DefaultView[0]["MOBILE_TEL"]); entity.mobile_adress = ExCast.zCStr(dt.DefaultView[0]["MOBILE_ADRESS"]); entity.url = ExCast.zCStr(dt.DefaultView[0]["URL"]); entity.customer_id = ExCast.zCStr(dt.DefaultView[0]["CUSTOMER_ID"]); entity.customer_nm = ExCast.zCStr(dt.DefaultView[0]["CUSTOMER_NAME"]); entity.divide_permission_id = ExCast.zCInt(dt.DefaultView[0]["DISPLAY_FLG"]); entity.divide_permission_nm = ExCast.zCStr(dt.DefaultView[0]["DISPLAY_DIVISION_NAME"]); entity.display_division_id = ExCast.zCInt(dt.DefaultView[0]["DISPLAY_FLG"]); entity.display_division_nm = ExCast.zCStr(dt.DefaultView[0]["DISPLAY_DIVISION_NAME"]); entity.lock_flg = (int)lockFlg; entity.memo = ExCast.zCStr(dt.DefaultView[0]["MEMO"]); #endregion } else { entity = null; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetSupplier", ex); entity = new EntitySupplier(); entity.MESSAGE = CLASS_NM + ".GetSupplier : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Select, "ID:" + Id.ToString()); return(entity); }
protected void Page_Load(object sender, EventArgs e) { string errMsg = ""; #region Parameter Get string rptKbn = ""; string pgId = ""; string random = ""; string _prm = ""; string[] prm; string viewFileName = ""; string viewFilePath = ""; try { random = Request.QueryString["random"]; viewFileName = Request.QueryString["viewFileName"]; viewFilePath = Request.QueryString["viewFilePath"]; viewFilePath = viewFilePath.Replace("@AAB@", @"\").Replace("@AAD@", "/"); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Parameter Get)", ex); errMsg = CLASS_NM + ".Page_Load(Parameter Get) : 予期せぬエラーが発生しました" + Environment.NewLine + ex.Message; } #endregion #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; if (string.IsNullOrEmpty(errMsg)) { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(認証処理) : 認証に失敗しました。" + Environment.NewLine + _message); return; } } #endregion #region Response try { if (errMsg != "") { Response.Write(errMsg); Response.Flush(); Response.Close(); } else { Response.ContentType = "application/pdf"; Response.TransmitFile(viewFilePath); Response.Flush(); Response.Close(); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Response)", ex); } #endregion }
public List <EntityInquiry> GetInquiry(string random, long no) { List <EntityInquiry> entityList = new List <EntityInquiry>(); #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { EntityInquiry entity = new EntityInquiry(); entity.MESSAGE = _message; entityList.Add(entity); return(entityList); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetInquiry(認証処理)", ex); EntityInquiry entity = new EntityInquiry(); entity.MESSAGE = CLASS_NM + ".GetInquiry : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();; entityList.Add(entity); return(entityList); } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); if (no == 0) { // 一覧表示時 #region SQL // 返答時 sb.Append("SELECT DISTINCT " + Environment.NewLine); sb.Append(" IH.NO " + Environment.NewLine); sb.Append(" ,IH.DATE " + Environment.NewLine); sb.Append(" ,IH.TIME " + Environment.NewLine); sb.Append(" ,IH.INQUIRY_DIVISION_ID " + Environment.NewLine); sb.Append(" ,NM1.DESCRIPTION AS INQUIRY_DIVISION_NAME " + Environment.NewLine); sb.Append(" ,IH.TITLE " + Environment.NewLine); sb.Append(" ,IH.INQUIRY_STATE_ID " + Environment.NewLine); sb.Append(" ,NM3.DESCRIPTION AS INQUIRY_STATE_NAME " + Environment.NewLine); sb.Append(" ,IH.INQUIRY_LEVEL_ID " + Environment.NewLine); sb.Append(" ,NM2.DESCRIPTION AS INQUIRY_LEVEL_NAME " + Environment.NewLine); sb.Append(" FROM SYS_T_INQUIRY_H AS IH" + Environment.NewLine); #region Join // 担当者(ヘッダ) sb.Append(" LEFT JOIN M_PERSON AS PS" + Environment.NewLine); sb.Append(" ON PS.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND PS.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND PS.COMPANY_ID = IH.COMPANY_ID " + Environment.NewLine); sb.Append(" AND PS.ID = IH.PERSON_ID" + Environment.NewLine); // 問い合わせ区分ID sb.Append(" LEFT JOIN SYS_M_NAME AS NM1" + Environment.NewLine); sb.Append(" ON NM1.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM1.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM1.DIVISION_ID = " + (int)CommonUtl.geNameKbn.INQUIRY_DIVISION_ID + Environment.NewLine); sb.Append(" AND NM1.ID = IH.INQUIRY_DIVISION_ID" + Environment.NewLine); // 問い合わせ緊急度ID sb.Append(" LEFT JOIN SYS_M_NAME AS NM2" + Environment.NewLine); sb.Append(" ON NM2.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM2.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM2.DIVISION_ID = " + (int)CommonUtl.geNameKbn.LEVEL_ID + Environment.NewLine); sb.Append(" AND NM2.ID = IH.INQUIRY_LEVEL_ID" + Environment.NewLine); // 問い合わせ状態ID sb.Append(" LEFT JOIN SYS_M_NAME AS NM3" + Environment.NewLine); sb.Append(" ON NM3.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM3.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM3.DIVISION_ID = " + (int)CommonUtl.geNameKbn.INQUIRY_STATE_ID + Environment.NewLine); sb.Append(" AND NM3.ID = IH.INQUIRY_STATE_ID" + Environment.NewLine); #endregion sb.Append(" WHERE IH.COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND IH.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" ORDER BY IH.DATE DESC " + Environment.NewLine); sb.Append(" ,IH.TIME DESC " + Environment.NewLine); #endregion } else { #region SQL // 返答時 sb.Append("SELECT IH.NO " + Environment.NewLine); sb.Append(" ,IH.COMPANY_ID " + Environment.NewLine); sb.Append(" ,CP.NAME AS COMPANY_NAME " + Environment.NewLine); sb.Append(" ,IH.GROUP_ID " + Environment.NewLine); sb.Append(" ,GP.NAME AS GROUP_NAME " + Environment.NewLine); sb.Append(" ,IH.PERSON_ID " + Environment.NewLine); sb.Append(" ,PS.NAME AS PERSON_NAME " + Environment.NewLine); sb.Append(" ,IH.DATE " + Environment.NewLine); sb.Append(" ,IH.TIME " + Environment.NewLine); sb.Append(" ,IH.TITLE " + Environment.NewLine); sb.Append(" ,IH.INQUIRY_DIVISION_ID " + Environment.NewLine); sb.Append(" ,NM1.DESCRIPTION AS INQUIRY_DIVISION_NAME " + Environment.NewLine); sb.Append(" ,IH.INQUIRY_LEVEL_ID " + Environment.NewLine); sb.Append(" ,NM2.DESCRIPTION AS INQUIRY_LEVEL_NAME " + Environment.NewLine); sb.Append(" ,IH.INQUIRY_STATE_ID " + Environment.NewLine); sb.Append(" ,NM3.DESCRIPTION AS INQUIRY_STATE_NAME " + Environment.NewLine); sb.Append(" ,IH.MEMO " + Environment.NewLine); sb.Append(" ,ID.REC_NO " + Environment.NewLine); sb.Append(" ,ID.DATE AS D_DATE" + Environment.NewLine); sb.Append(" ,ID.TIME AS D_TIME" + Environment.NewLine); sb.Append(" ,ID.KBN " + Environment.NewLine); sb.Append(" ,ID.PERSON_ID AS D_PERSON_ID " + Environment.NewLine); sb.Append(" ,PS2.NAME AS D_PERSON_NAME " + Environment.NewLine); sb.Append(" ,ID.SUPPORT_PERSON_NAME " + Environment.NewLine); sb.Append(" ,ID.UPLOAD_FILE_PATH1 " + Environment.NewLine); sb.Append(" ,ID.UPLOAD_FILE_PATH2 " + Environment.NewLine); sb.Append(" ,ID.UPLOAD_FILE_PATH3 " + Environment.NewLine); sb.Append(" ,ID.UPLOAD_FILE_PATH4 " + Environment.NewLine); sb.Append(" ,ID.UPLOAD_FILE_PATH5 " + Environment.NewLine); sb.Append(" ,ID.CONTENT " + Environment.NewLine); sb.Append(" FROM SYS_T_INQUIRY_H AS IH" + Environment.NewLine); #region Join sb.Append(" INNER JOIN SYS_T_INQUIRY_D AS ID" + Environment.NewLine); sb.Append(" ON ID.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND ID.NO = IH.NO" + Environment.NewLine); // 会社 sb.Append(" LEFT JOIN SYS_M_COMPANY AS CP" + Environment.NewLine); sb.Append(" ON CP.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND CP.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND CP.ID = IH.COMPANY_ID " + Environment.NewLine); // グループ sb.Append(" LEFT JOIN SYS_M_COMPANY_GROUP AS GP" + Environment.NewLine); sb.Append(" ON GP.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND GP.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND GP.ID = IH.GROUP_ID " + Environment.NewLine); // 担当者(ヘッダ) sb.Append(" LEFT JOIN M_PERSON AS PS" + Environment.NewLine); sb.Append(" ON PS.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND PS.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND PS.COMPANY_ID = IH.COMPANY_ID " + Environment.NewLine); sb.Append(" AND PS.ID = IH.PERSON_ID" + Environment.NewLine); // 担当者(明細) sb.Append(" LEFT JOIN M_PERSON AS PS2" + Environment.NewLine); sb.Append(" ON PS2.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND PS2.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND PS2.COMPANY_ID = IH.COMPANY_ID " + Environment.NewLine); sb.Append(" AND PS2.ID = ID.PERSON_ID" + Environment.NewLine); // 問い合わせ区分ID sb.Append(" LEFT JOIN SYS_M_NAME AS NM1" + Environment.NewLine); sb.Append(" ON NM1.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM1.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM1.DIVISION_ID = " + (int)CommonUtl.geNameKbn.INQUIRY_DIVISION_ID + Environment.NewLine); sb.Append(" AND NM1.ID = IH.INQUIRY_DIVISION_ID" + Environment.NewLine); // 問い合わせ緊急度ID sb.Append(" LEFT JOIN SYS_M_NAME AS NM2" + Environment.NewLine); sb.Append(" ON NM2.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM2.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM2.DIVISION_ID = " + (int)CommonUtl.geNameKbn.LEVEL_ID + Environment.NewLine); sb.Append(" AND NM2.ID = IH.INQUIRY_LEVEL_ID" + Environment.NewLine); // 問い合わせ緊急度ID sb.Append(" LEFT JOIN SYS_M_NAME AS NM3" + Environment.NewLine); sb.Append(" ON NM3.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM3.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM3.DIVISION_ID = " + (int)CommonUtl.geNameKbn.INQUIRY_STATE_ID + Environment.NewLine); sb.Append(" AND NM3.ID = IH.INQUIRY_STATE_ID" + Environment.NewLine); #endregion sb.Append(" WHERE IH.COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND IH.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND IH.NO = " + no + Environment.NewLine); sb.Append(" ORDER BY IH.DATE DESC " + Environment.NewLine); sb.Append(" ,IH.TIME DESC " + Environment.NewLine); sb.Append(" ,ID.REC_NO DESC " + Environment.NewLine); #endregion } dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { EntityInquiry entity = new EntityInquiry(); // 排他制御 DataPgLock.geLovkFlg lockFlg = DataPgLock.geLovkFlg.UnLock; if (no != 0) // 返答時 { string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, no.ToString(), ipAdress, db, out lockFlg); if (strErr != "") { entity.MESSAGE = CLASS_NM + ".GetInquiry : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr; } } #region Set Entity entity.no = ExCast.zCLng(dt.DefaultView[i]["NO"]); entity.date_time = ExCast.zDateNullToDefault(dt.DefaultView[i]["DATE"]) + " " + ExCast.zCStr(dt.DefaultView[i]["TIME"]); entity.title = ExCast.zCStr(dt.DefaultView[i]["TITLE"]); entity.inquiry_division_id = ExCast.zCInt(dt.DefaultView[i]["INQUIRY_DIVISION_ID"]); entity.inquiry_division_nm = ExCast.zCStr(dt.DefaultView[i]["INQUIRY_DIVISION_NAME"]); entity.inquiry_level_id = ExCast.zCInt(dt.DefaultView[i]["INQUIRY_LEVEL_ID"]); entity.inquiry_level_nm = ExCast.zCStr(dt.DefaultView[i]["INQUIRY_LEVEL_NAME"]); entity.inquiry_level_state_id = ExCast.zCInt(dt.DefaultView[i]["INQUIRY_STATE_ID"]); entity.inquiry_level_state_nm = ExCast.zCStr(dt.DefaultView[i]["INQUIRY_STATE_NAME"]); if (no != 0) { // 返答時 entity.company_id = ExCast.zCInt(dt.DefaultView[i]["COMPANY_ID"]); entity.company_nm = ExCast.zCStr(dt.DefaultView[i]["COMPANY_NAME"]); entity.gropu_id = ExCast.zCInt(dt.DefaultView[i]["GROUP_ID"]); entity.gropu_nm = ExCast.zCStr(dt.DefaultView[i]["GROUP_NAME"]); entity.person_id = ExCast.zCInt(dt.DefaultView[i]["PERSON_ID"]); entity.person_nm = ExCast.zCStr(dt.DefaultView[i]["PERSON_NAME"]); entity.rec_no = ExCast.zCInt(dt.DefaultView[i]["REC_NO"]); entity.d_date_time = ExCast.zDateNullToDefault(dt.DefaultView[i]["D_DATE"]) + " " + ExCast.zCStr(dt.DefaultView[i]["D_TIME"]); entity.kbn = ExCast.zCInt(dt.DefaultView[i]["KBN"]); entity.d_person_id = ExCast.zCInt(dt.DefaultView[i]["D_PERSON_ID"]); entity.d_person_nm = ExCast.zCStr(dt.DefaultView[i]["D_PERSON_NAME"]); entity.support_person_nm = ExCast.zCStr(dt.DefaultView[i]["SUPPORT_PERSON_NAME"]); entity.content = ExCast.zCStr(dt.DefaultView[i]["CONTENT"]); entity.lock_flg = (int)lockFlg; entity.memo = ExCast.zCStr(dt.DefaultView[0]["MEMO"]); } #endregion entityList.Add(entity); } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetInquiry", ex); entityList.Clear(); EntityInquiry entity = new EntityInquiry(); entity.MESSAGE = CLASS_NM + ".GetInquiry : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString();; entityList.Add(entity); return(entityList); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Select, "NO:" + no.ToString()); return(entityList); }
public string UpdateAuthority(string random, List <EntityAuthority> entity, int _user_id) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(認証処理)", ex); return(Authority_NM + ".UpdateAuthority : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string str_authority_kbn = ""; #endregion #region 権限不可ユーザ0件チェック try { bool _flg = true; for (int i = 0; i <= entity.Count - 1; i++) { if (entity[i].authority_kbn < 2 && entity[i].pg_id == "AuthorityMst") { _flg = false; } } if (_flg == false) { ExMySQLData dbSelect = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); #region SQL sb.Append("SELECT MT.USER_ID " + Environment.NewLine); sb.Append(" FROM M_AUTHORITY AS MT" + Environment.NewLine); #region Join sb.Append(" INNER JOIN SYS_M_USER AS UR" + Environment.NewLine); sb.Append(" ON UR.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND UR.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND UR.COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND UR.ID = MT.USER_ID " + Environment.NewLine); sb.Append(" AND UR.ID <> " + _user_id + Environment.NewLine); #endregion sb.Append(" WHERE MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.PG_ID = 'AuthorityMst' " + Environment.NewLine); sb.Append(" AND MT.AUTHORITY_KBN >= 2 " + Environment.NewLine); #endregion dt = dbSelect.GetDataTable(sb.ToString()); if (dt.DefaultView.Count == 0) { return("権限を付加できるユーザが0件になる為、更新できません。"); } dbSelect = null; } } catch (Exception ex) { CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(Check)", ex); return(Authority_NM + ".UpdateAuthority(Check) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Databese Open try { db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR])); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(DbOpen)", ex); return(Authority_NM + ".UpdateAuthority(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(BeginTransaction)", ex); return(Authority_NM + ".UpdateAuthority(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Delete try { #region Delete SQL sb.Length = 0; sb.Append("DELETE FROM M_AUTHORITY " + Environment.NewLine); sb.Append(" WHERE USER_ID = " + _user_id + Environment.NewLine); #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(Delete)", ex); return(Authority_NM + ".UpdateAuthority(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Insert try { for (int i = 0; i <= entity.Count - 1; i++) { #region Insert SQL sb.Length = 0; sb.Append("INSERT INTO M_AUTHORITY " + Environment.NewLine); sb.Append(" ( USER_ID" + Environment.NewLine); sb.Append(" , PG_ID" + Environment.NewLine); sb.Append(" , AUTHORITY_KBN" + Environment.NewLine); sb.Append(" , MEMO" + Environment.NewLine); sb.Append(" , DISPLAY_INDEX" + Environment.NewLine); sb.Append(" , DISPLAY_FLG" + Environment.NewLine); sb.Append(" , UPDATE_FLG" + Environment.NewLine); sb.Append(" , DELETE_FLG" + Environment.NewLine); sb.Append(" , CREATE_PG_ID" + Environment.NewLine); sb.Append(" , CREATE_ADRESS" + Environment.NewLine); sb.Append(" , CREATE_USER_ID" + Environment.NewLine); sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine); sb.Append(" , CREATE_DATE" + Environment.NewLine); sb.Append(" , CREATE_TIME" + Environment.NewLine); sb.Append(" , UPDATE_PG_ID" + Environment.NewLine); sb.Append(" , UPDATE_ADRESS" + Environment.NewLine); sb.Append(" , UPDATE_USER_ID" + Environment.NewLine); sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine); sb.Append(" , UPDATE_DATE" + Environment.NewLine); sb.Append(" , UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("SELECT " + _user_id + Environment.NewLine); // USER_ID sb.Append(" ," + ExEscape.zRepStr(entity[i].pg_id) + Environment.NewLine); // PG_ID sb.Append(" ," + entity[i].authority_kbn + Environment.NewLine); // AUTHORITY_KBN sb.Append(" ," + ExEscape.zRepStr(entity[i].memo) + Environment.NewLine); // MEMO sb.Append(" ," + entity[i].display_index + Environment.NewLine); // DISPLAY_INDEX sb.Append(" ,1" + Environment.NewLine); // DISPLAY_FLG sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins, PG_NM, "M_AUTHORITY", ExCast.zCInt(personId), _user_id.ToString(), ipAdress, userId)); #endregion db.ExecuteSQL(sb.ToString(), false); if (entity[i].pg_id == "ReportTotal" && _user_id == ExCast.zCInt(userId)) { str_authority_kbn = ExCast.zCStr(entity[i].authority_kbn); HttpContext.Current.Session[ExSession.REPORT_TOTAL_AUTHORITY_KBN] = entity[i].authority_kbn; } } } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(Insert)", ex); return(Authority_NM + ".UpdateAuthority(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region PG排他制御 try { DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(DelLockPg)", ex); return(Authority_NM + ".UpdateAuthority(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(CommitTransaction)", ex); return(Authority_NM + ".UpdateAuthority(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(DbClose)", ex); return(Authority_NM + ".UpdateAuthority(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.DeleteAndInsert, ""); } catch (Exception ex) { CommonUtl.ExLogger.Error(Authority_NM + ".UpdateAuthority(Add Evidence)", ex); return(Authority_NM + ".UpdateAuthority(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion if (str_authority_kbn != "") { HttpContext.Current.Session[ExSession.REPORT_TOTAL_AUTHORITY_KBN] = ExCast.zCInt(str_authority_kbn); } return(""); }
public string ChkClassExist(string random, int classKbn, string Id) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".ChkClassExist(認証処理)", ex); return(CLASS_NM + ".ChkClassExist : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString());; } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); int _classKbn = ((classKbn - 1)) * 3 + 1; #region Exist Data bool _ret = false; switch (_classKbn) { case 1: // 得意先分類 _ret = DataExists.IsExistData(db, companyId, "", "M_CUSTOMER", "GROUP1_ID", string.Format("{0:000", ExCast.zCInt(Id)), CommonUtl.geStrOrNumKbn.String); if (_ret == true) { return("得意先分類ID : " + Id + " は得意先マスタで使用されている為、削除できません。"); } break; case 2: // 商品分類 _ret = DataExists.IsExistData(db, companyId, "", "M_COMMODITY", "GROUP1_ID", string.Format("{0:000", ExCast.zCInt(Id)), CommonUtl.geStrOrNumKbn.String); if (_ret == true) { return("商品分類ID : " + Id + " は商品マスタで使用されている為、削除できません。"); } break; case 3: // 仕入先分類 _ret = DataExists.IsExistData(db, companyId, "", "M_PURCHASE", "GROUP1_ID", string.Format("{0:000", ExCast.zCInt(Id)), CommonUtl.geStrOrNumKbn.String); if (_ret == true) { return("仕入先分類ID : " + Id + " は仕入先マスタで使用されている為、削除できません。"); } break; } #endregion } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".ChkClassExist", ex); return(CLASS_NM + ".ChkClassExist : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString()); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Select, ""); return(""); }
protected void Page_Load(object sender, EventArgs e) { string errMsg = ""; #region Parameter Get string random = ""; string upLoadFileName = ""; try { random = Request.QueryString["random"]; upLoadFileName = Request.QueryString["upLoadFileName"]; } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Parameter Get)", ex); errMsg = CLASS_NM + ".Page_Load(Parameter Get) : 予期せぬエラーが発生しました" + Environment.NewLine + ex.Message; } #endregion #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; if (string.IsNullOrEmpty(errMsg)) { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(認証処理) : 認証に失敗しました。" + Environment.NewLine + _message); return; } } #endregion #region UpLoad File Save HttpPostedFile posted = Request.Files[0]; string dir = ""; string date = ""; string time = ""; string millisecond = ""; DateTime now = DateTime.Now; date = now.ToString("yyyyMMdd"); time = now.ToString("HHmmss"); millisecond = now.Millisecond.ToString(); dir = date + time + millisecond; try { if (string.IsNullOrEmpty(errMsg)) { posted.SaveAs(CommonUtl.gstrFileUpLoadDir + dir + "\\" + upLoadFileName); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(UpLoad File Save)", ex); errMsg = CLASS_NM + ".Page_Load(UpLoad File Save) : 予期せぬエラーが発生しました" + Environment.NewLine + ex.Message; } #endregion #region Response string ret_Msg = ""; try { Response.ContentType = "application/octet-stream"; Response.AppendHeader("Content-Disposition", "attachment; filename="); Response.Flush(); if (errMsg != "") { ret_Msg = "error message start ==>" + errMsg; } else { ret_Msg = "success file upload ==>" + dir; } Response.Write(ret_Msg); Response.Flush(); Response.Close(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Response)", ex); } #endregion }
public List <EntityClass> GetClass(string random, int classKbn) { EntityClass entity; List <EntityClass> entityList = new List <EntityClass>(); #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { entity = new EntityClass(); entity.MESSAGE = _message; entityList.Add(entity); return(entityList); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetClass(認証処理)", ex); entity = new EntityClass(); entity.MESSAGE = CLASS_NM + ".GetClass : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();; entityList.Add(entity); return(entityList); } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); #region SQL int _classKbn = ((classKbn - 1)) * 3 + 1; sb.Append("SELECT MT.* " + Environment.NewLine); sb.Append(" ,NM.DESCRIPTION AS DISPLAY_DIVISION_NAME " + Environment.NewLine); sb.Append(" FROM M_CLASS AS MT" + Environment.NewLine); #region Join // 表示区分 sb.Append(" LEFT JOIN SYS_M_NAME AS NM" + Environment.NewLine); sb.Append(" ON NM.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM.DIVISION_ID = " + (int)CommonUtl.geNameKbn.DISPLAY_DIVISION_ID + Environment.NewLine); sb.Append(" AND NM.ID = MT.DISPLAY_FLG" + Environment.NewLine); #endregion sb.Append(" WHERE MT.COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.CLASS_DIVISION_ID = " + _classKbn.ToString() + Environment.NewLine); sb.Append(" ORDER BY MT.COMPANY_ID " + Environment.NewLine); sb.Append(" ,MT.ID " + Environment.NewLine); #endregion dt = db.GetDataTable(sb.ToString()); // 排他制御 DataPgLock.geLovkFlg lockFlg; string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, _classKbn.ToString(), ipAdress, db, out lockFlg); if (strErr != "") { entity = new EntityClass(); entity.MESSAGE = CLASS_NM + ".GetCommodity : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr; entityList.Add(entity); return(entityList); } if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { #region Set Entity entity = new EntityClass(); entity.id = ExCast.zCStr(dt.DefaultView[i]["ID"]); entity.class_divition_id = ExCast.zCInt(dt.DefaultView[i]["CLASS_DIVISION_ID"]); entity.name = ExCast.zCStr(dt.DefaultView[i]["NAME"]); entity.display_division_id = ExCast.zCInt(dt.DefaultView[i]["DISPLAY_FLG"]); entity.display_division_nm = ExCast.zCStr(dt.DefaultView[i]["DISPLAY_DIVISION_NAME"]); entity.memo = ExCast.zCStr(dt.DefaultView[i]["MEMO"]); entity.lock_flg = (int)lockFlg; entityList.Add(entity); #endregion } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetClass", ex); entityList.Clear(); entity = new EntityClass(); entity.MESSAGE = CLASS_NM + ".GetClass : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); entityList.Add(entity); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Select, ""); return(entityList); }
public EntityCommodity GetCommodity(string random, string Id) { EntityCommodity entity; #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { entity = new EntityCommodity(); entity.MESSAGE = _message; return(entity); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetCommodity(認証処理)", ex); entity = new EntityCommodity(); entity.MESSAGE = CLASS_NM + ".GetCommodity : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();; return(entity); } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); #region SQL sb.Append("SELECT MT.* " + Environment.NewLine); sb.Append(" ,PU.NAME AS MAIN_PURCHASE_NAME " + Environment.NewLine); sb.Append(" ,NM1.DESCRIPTION AS UNIT_NAME " + Environment.NewLine); sb.Append(" ,NM2.DESCRIPTION AS TAXATION_DIVISION_NAME " + Environment.NewLine); sb.Append(" ,NM3.DESCRIPTION AS INVENTORY_MANAGEMENT_DIVISION_NAME " + Environment.NewLine); sb.Append(" ,NM4.DESCRIPTION AS INVENTORY_EVALUATION_NAME " + Environment.NewLine); sb.Append(" ,CL1.NAME AS GROUP1_NAME " + Environment.NewLine); sb.Append(" ,CL2.NAME AS GROUP2_NAME " + Environment.NewLine); sb.Append(" ,CL3.NAME AS GROUP3_NAME " + Environment.NewLine); sb.Append(" ,NM.DESCRIPTION AS DISPLAY_DIVISION_NAME " + Environment.NewLine); sb.Append(" FROM M_COMMODITY AS MT" + Environment.NewLine); #region Join // 仕入先 sb.Append(" LEFT JOIN M_PURCHASE AS PU" + Environment.NewLine); sb.Append(" ON PU.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND PU.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND PU.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine); sb.Append(" AND PU.ID = MT.MAIN_PURCHASE_ID" + Environment.NewLine); // 単位 sb.Append(" LEFT JOIN SYS_M_NAME AS NM1" + Environment.NewLine); sb.Append(" ON NM1.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM1.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM1.DIVISION_ID = " + (int)CommonUtl.geNameKbn.UNIT_ID + Environment.NewLine); sb.Append(" AND NM1.ID = MT.UNIT_ID" + Environment.NewLine); // 課税区分 sb.Append(" LEFT JOIN SYS_M_NAME AS NM2" + Environment.NewLine); sb.Append(" ON NM2.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM2.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM2.DIVISION_ID = " + (int)CommonUtl.geNameKbn.TAX_DIVISION_ID + Environment.NewLine); sb.Append(" AND NM2.ID = MT.TAXATION_DIVISION_ID" + Environment.NewLine); // 在庫管理区分 sb.Append(" LEFT JOIN SYS_M_NAME AS NM3" + Environment.NewLine); sb.Append(" ON NM3.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM3.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM3.DIVISION_ID = " + (int)CommonUtl.geNameKbn.INVENTORY_DIVISION_ID + Environment.NewLine); sb.Append(" AND NM3.ID = MT.INVENTORY_MANAGEMENT_DIVISION_ID" + Environment.NewLine); // 在庫評価 sb.Append(" LEFT JOIN SYS_M_NAME AS NM4" + Environment.NewLine); sb.Append(" ON NM4.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM4.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM4.DIVISION_ID = " + (int)CommonUtl.geNameKbn.INVENTORY_DIVISION_ID + Environment.NewLine); sb.Append(" AND NM4.ID = MT.INVENTORY_EVALUATION_ID" + Environment.NewLine); // 商品分類1 sb.Append(" LEFT JOIN M_CLASS AS CL1" + Environment.NewLine); sb.Append(" ON CL1.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND CL1.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND CL1.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine); sb.Append(" AND CL1.CLASS_DIVISION_ID = " + (int)CommonUtl.geMGroupKbn.CommodityGrouop1 + Environment.NewLine); sb.Append(" AND CL1.ID = MT.GROUP1_ID" + Environment.NewLine); // 商品分類2 sb.Append(" LEFT JOIN M_CLASS AS CL2" + Environment.NewLine); sb.Append(" ON CL2.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND CL2.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND CL2.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine); sb.Append(" AND CL2.CLASS_DIVISION_ID = " + (int)CommonUtl.geMGroupKbn.CommodityGrouop2 + Environment.NewLine); sb.Append(" AND CL2.ID = MT.GROUP2_ID" + Environment.NewLine); // 商品分類3 sb.Append(" LEFT JOIN M_CLASS AS CL3" + Environment.NewLine); sb.Append(" ON CL3.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND CL3.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND CL3.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine); sb.Append(" AND CL3.CLASS_DIVISION_ID = " + (int)CommonUtl.geMGroupKbn.CommodityGrouop3 + Environment.NewLine); sb.Append(" AND CL3.ID = MT.GROUP3_ID" + Environment.NewLine); // 表示区分 sb.Append(" LEFT JOIN SYS_M_NAME AS NM" + Environment.NewLine); sb.Append(" ON NM.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND NM.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND NM.DIVISION_ID = " + (int)CommonUtl.geNameKbn.DISPLAY_DIVISION_ID + Environment.NewLine); sb.Append(" AND NM.ID = MT.DISPLAY_FLG" + Environment.NewLine); #endregion sb.Append(" WHERE MT.COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.SET_COMMODITY_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); sb.Append(" ORDER BY MT.COMPANY_ID " + Environment.NewLine); sb.Append(" ,MT.ID " + Environment.NewLine); #endregion dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { entity = new EntityCommodity(); // 排他制御 DataPgLock.geLovkFlg lockFlg; string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, ExCast.zNumZeroNothingFormat(Id), ipAdress, db, out lockFlg); if (strErr != "") { entity.MESSAGE = CLASS_NM + ".GetCommodity : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr; } #region Set Entity entity.id = ExCast.zCStr(dt.DefaultView[0]["ID"]); entity.name = ExCast.zCStr(dt.DefaultView[0]["NAME"]); entity.kana = ExCast.zCStr(dt.DefaultView[0]["KANA"]); entity.unit_id = ExCast.zCInt(dt.DefaultView[0]["UNIT_ID"]); entity.unit_nm = ExCast.zCStr(dt.DefaultView[0]["UNIT_NAME"]); entity.enter_number = ExCast.zCDbl(dt.DefaultView[0]["ENTER_NUMBER"]); entity.number_decimal_digit = ExCast.zCInt(dt.DefaultView[0]["NUMBER_DECIMAL_DIGIT"]); entity.unit_decimal_digit = ExCast.zCInt(dt.DefaultView[0]["UNIT_DECIMAL_DIGIT"]); entity.taxation_divition_id = ExCast.zCInt(dt.DefaultView[0]["TAXATION_DIVISION_ID"]); entity.taxation_divition_nm = ExCast.zCStr(dt.DefaultView[0]["TAXATION_DIVISION_NAME"]); entity.inventory_management_division_id = ExCast.zCInt(dt.DefaultView[0]["INVENTORY_MANAGEMENT_DIVISION_ID"]); entity.inventory_management_division_nm = ExCast.zCStr(dt.DefaultView[0]["INVENTORY_MANAGEMENT_DIVISION_NAME"]); entity.purchase_lot = ExCast.zCDbl(dt.DefaultView[0]["PURCHASE_LOT"]); entity.lead_time = ExCast.zCInt(dt.DefaultView[0]["LEAD_TIME"]); entity.just_inventory_number = ExCast.zCDbl(dt.DefaultView[0]["JUST_INVENTORY_NUMBER"]); entity.inventory_number = ExCast.zCDbl(dt.DefaultView[0]["INVENTORY_NUMBER"]); entity.inventory_evaluation_id = ExCast.zCInt(dt.DefaultView[0]["INVENTORY_EVALUATION_ID"]); entity.inventory_evaluation_nm = ExCast.zCStr(dt.DefaultView[0]["INVENTORY_EVALUATION_NAME"]); entity.main_purchase_id = ExCast.zCStr(dt.DefaultView[0]["MAIN_PURCHASE_ID"]); entity.main_purchase_nm = ExCast.zCStr(dt.DefaultView[0]["MAIN_PURCHASE_NAME"]); entity.retail_price_skip_tax = ExCast.zCDbl(dt.DefaultView[0]["RETAIL_PRICE_SKIP_TAX"]); entity.retail_price_before_tax = ExCast.zCDbl(dt.DefaultView[0]["RETAIL_PRICE_BEFORE_TAX"]); entity.sales_unit_price_skip_tax = ExCast.zCDbl(dt.DefaultView[0]["SALES_UNIT_PRICE_SKIP_TAX"]); entity.sales_unit_price_before_tax = ExCast.zCDbl(dt.DefaultView[0]["SALES_UNIT_PRICE_BEFORE_TAX"]); entity.sales_cost_price_skip_tax = ExCast.zCDbl(dt.DefaultView[0]["SALES_COST_PRICE_SKIP_TAX"]); entity.sales_cost_price_before_tax = ExCast.zCDbl(dt.DefaultView[0]["SALES_COST_PRICE_BEFORE_TAX"]); entity.purchase_unit_price_skip_tax = ExCast.zCDbl(dt.DefaultView[0]["PURCHASE_UNIT_PRICE_SKIP_TAX"]); entity.purchase_unit_price_before_tax = ExCast.zCDbl(dt.DefaultView[0]["PURCHASE_UNIT_PRICE_BEFORE_TAX"]); entity.group1_id = ExCast.zCStr(dt.DefaultView[0]["GROUP1_ID"]); entity.group1_nm = ExCast.zCStr(dt.DefaultView[0]["GROUP1_NAME"]); entity.group2_id = ExCast.zCStr(dt.DefaultView[0]["GROUP2_ID"]); entity.group2_nm = ExCast.zCStr(dt.DefaultView[0]["GROUP2_NAME"]); entity.group3_id = ExCast.zCStr(dt.DefaultView[0]["GROUP3_ID"]); entity.group3_nm = ExCast.zCStr(dt.DefaultView[0]["GROUP3_NAME"]); entity.display_division_id = ExCast.zCInt(dt.DefaultView[0]["DISPLAY_FLG"]); entity.display_division_nm = ExCast.zCStr(dt.DefaultView[0]["DISPLAY_DIVISION_NAME"]); entity.memo = ExCast.zCStr(dt.DefaultView[0]["MEMO"]); entity.lock_flg = (int)lockFlg; #endregion } else { entity = null; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetCommodity", ex); entity = new EntityCommodity(); entity.MESSAGE = CLASS_NM + ".GetCommodity : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Select, "ID:" + Id.ToString()); return(entity); }
protected void Page_Load(object sender, EventArgs e) { string errMsg = ""; #region Parameter Get string rptKbn = ""; string pgId = ""; string random = ""; string _prm = ""; string[] prm; string downLoadFileName = ""; string downLoadFilePath = ""; try { rptKbn = Request.QueryString["rptKbn"]; pgId = Request.QueryString["pgId"]; random = Request.QueryString["random"]; downLoadFileName = Request.QueryString["deleteFileName"]; downLoadFilePath = Request.QueryString["deleteFilePath"]; downLoadFilePath = downLoadFilePath.Replace("@AAB@", @"\").Replace("@AAD@", "/"); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Parameter Get)", ex); errMsg = CLASS_NM + ".Page_Load(Parameter Get) : 予期せぬエラーが発生しました" + Environment.NewLine + ex.Message; } #endregion #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; if (string.IsNullOrEmpty(errMsg)) { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(認証処理) : 認証に失敗しました。" + Environment.NewLine + _message); return; } } #endregion #region Report Delete try { if (string.IsNullOrEmpty(errMsg)) { if (!ExFile.IsFileOpenTime(downLoadFilePath, 100)) { errMsg = CLASS_NM + ".Page_Load(Report Delete) : 別のプロセスで使用中の為、ファイルを削除できません。"; } else { string _directory = downLoadFilePath.Replace(downLoadFileName, ""); if (System.IO.Directory.Exists(_directory)) { System.IO.Directory.Delete(_directory, true); } } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Report Delete)", ex); errMsg = CLASS_NM + ".Page_Load(Report Delete) : 予期せぬエラーが発生しました" + Environment.NewLine + ex.Message; } #endregion #region Response string ret_Msg = ""; try { Response.ContentType = "application/octet-stream"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + downLoadFileName); Response.Flush(); if (errMsg != "") { ret_Msg = "error message start ==>" + errMsg; } else { ret_Msg = "success file delete"; } Response.Write(ret_Msg); Response.Flush(); Response.Close(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Response)", ex); } #endregion }
public string UpdateClass(string random, List <EntityClass> entity, int classKbn) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateClass(認証処理)", ex); return(CLASS_NM + ".UpdateClass : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string _Id = ""; int _classKbn = 0; #endregion #region データ存在チェック sb = new StringBuilder(); #region SQL _classKbn = ((classKbn - 1)) * 3 + 1; sb.Length = 0; sb.Append("SELECT MT.* " + Environment.NewLine); sb.Append(" FROM M_CLASS AS MT" + Environment.NewLine); sb.Append(" WHERE MT.COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.CLASS_DIVISION_ID = " + _classKbn.ToString() + Environment.NewLine); sb.Append(" ORDER BY MT.COMPANY_ID " + Environment.NewLine); sb.Append(" ,MT.ID " + Environment.NewLine); #endregion db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); dt = db.GetDataTable(sb.ToString()); string ret_msg = ""; if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { long lngClassId = ExCast.zCLng(dt.DefaultView[i]["ID"]); bool exists_flg = false; for (int i_ = 0; i_ <= entity.Count - 1; i_++) { if (ExCast.zCLng(entity[i_].id) == lngClassId) { exists_flg = true; } } string strClassId = string.Format("{0:000}", ExCast.zCDbl(lngClassId)); if (exists_flg == false) { bool _ret = false; switch (classKbn) { case 1: // 得意先分類 _ret = DataExists.IsExistData(db, companyId, "", "M_CUSTOMER", "GROUP1_ID", strClassId, CommonUtl.geStrOrNumKbn.String); if (_ret == true) { ret_msg += "得意先分類ID : " + strClassId + " は得意先マスタで使用されている為、削除できません。" + Environment.NewLine; } break; case 2: // 商品分類 _ret = DataExists.IsExistData(db, companyId, "", "M_COMMODITY", "GROUP1_ID", strClassId, CommonUtl.geStrOrNumKbn.String); if (_ret == true) { ret_msg += "商品分類ID : " + strClassId + " は商品マスタで使用されている為、削除できません。" + Environment.NewLine; } break; case 3: // 仕入先分類 _ret = DataExists.IsExistData(db, companyId, "", "M_PURCHASE", "GROUP1_ID", strClassId, CommonUtl.geStrOrNumKbn.String); if (_ret == true) { ret_msg += "仕入先分類ID : " + strClassId + " は仕入先マスタで使用されている為、削除できません。" + Environment.NewLine; } break; } } } if (!string.IsNullOrEmpty(ret_msg)) { return(ret_msg); } } #endregion #region Databese Open try { db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR])); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateClass(DbOpen)", ex); return(CLASS_NM + ".UpdateClass(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateClass(BeginTransaction)", ex); return(CLASS_NM + ".UpdateClass(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Delete try { #region Delete SQL _classKbn = ((classKbn - 1)) * 3 + 1; sb.Length = 0; sb.Append("DELETE FROM M_CLASS " + Environment.NewLine); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND CLASS_DIVISION_ID = " + _classKbn.ToString() + Environment.NewLine); #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateClass(Delete)", ex); return(CLASS_NM + ".UpdateClass(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Insert try { for (int i = 0; i <= entity.Count - 1; i++) { // 空行は無視する if (!string.IsNullOrEmpty(entity[i].id)) { #region Insert SQL sb.Length = 0; sb.Append("INSERT INTO M_CLASS " + Environment.NewLine); sb.Append(" ( COMPANY_ID" + Environment.NewLine); sb.Append(" , CLASS_DIVISION_ID" + Environment.NewLine); sb.Append(" , ID" + Environment.NewLine); sb.Append(" , NAME" + Environment.NewLine); sb.Append(" , MEMO" + Environment.NewLine); sb.Append(" , DISPLAY_FLG" + Environment.NewLine); sb.Append(" , UPDATE_FLG" + Environment.NewLine); sb.Append(" , DELETE_FLG" + Environment.NewLine); sb.Append(" , CREATE_PG_ID" + Environment.NewLine); sb.Append(" , CREATE_ADRESS" + Environment.NewLine); sb.Append(" , CREATE_USER_ID" + Environment.NewLine); sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine); sb.Append(" , CREATE_DATE" + Environment.NewLine); sb.Append(" , CREATE_TIME" + Environment.NewLine); sb.Append(" , UPDATE_PG_ID" + Environment.NewLine); sb.Append(" , UPDATE_ADRESS" + Environment.NewLine); sb.Append(" , UPDATE_USER_ID" + Environment.NewLine); sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine); sb.Append(" , UPDATE_DATE" + Environment.NewLine); sb.Append(" , UPDATE_TIME" + Environment.NewLine); sb.Append(")" + Environment.NewLine); sb.Append("SELECT " + companyId + Environment.NewLine); // COMPANY_ID sb.Append(" ," + _classKbn.ToString() + Environment.NewLine); // Class_DIVISION_ID sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroFormat("{0:000}", entity[i].id)) + Environment.NewLine); // ID sb.Append(" ," + ExEscape.zRepStr(entity[i].name) + Environment.NewLine); // NAME sb.Append(" ," + ExEscape.zRepStr(entity[i].memo) + Environment.NewLine); // MEMO sb.Append(" ," + entity[i].display_division_id + Environment.NewLine); // DISPLAY_FLG sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins, PG_NM, "M_Class", ExCast.zCInt(personId), _Id, ipAdress, userId)); #endregion db.ExecuteSQL(sb.ToString(), false); } } } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateClass(Insert)", ex); return(CLASS_NM + ".UpdateClass(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region PG排他制御 try { DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateClass(DelLockPg)", ex); return(CLASS_NM + ".UpdateClass(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateClass(CommitTransaction)", ex); return(CLASS_NM + ".UpdateClass(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateClass(DbClose)", ex); return(CLASS_NM + ".UpdateClass(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.DeleteAndInsert, ""); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateClass(Add Evidence)", ex); return(CLASS_NM + ".UpdateClass(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion return(""); }
public string UpdateCompany(string random, int type, EntityCompany entity) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(認証処理)", ex); return(CLASS_NM + ".UpdateCompany : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string _Id = ""; #endregion #region Databese Open try { db = new ExMySQLData(); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(DbOpen)", ex); return(CLASS_NM + ".UpdateCompany(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(BeginTransaction)", ex); return(CLASS_NM + ".UpdateCompany(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Update if (type == 0) { try { #region Company SQL sb.Length = 0; sb.Append("UPDATE SYS_M_COMPANY " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 0)); sb.Append(" ,NAME = " + ExEscape.zRepStr(entity.name) + Environment.NewLine); sb.Append(" ,KANA = " + ExEscape.zRepStr(entity.kana) + Environment.NewLine); sb.Append(" ,ZIP_CODE = " + ExCast.zNullToZero(entity.zip_code_from + entity.zip_code_to) + Environment.NewLine); sb.Append(" ,PREFECTURE_ID = " + entity.prefecture_id + Environment.NewLine); sb.Append(" ,CITY_ID = " + entity.city_id + Environment.NewLine); sb.Append(" ,TOWN_ID = " + entity.town_id + Environment.NewLine); sb.Append(" ,ADRESS_CITY = " + ExEscape.zRepStr(entity.adress_city) + Environment.NewLine); sb.Append(" ,ADRESS_TOWN = " + ExEscape.zRepStr(entity.adress_town) + Environment.NewLine); sb.Append(" ,ADRESS1 = " + ExEscape.zRepStr(entity.adress1) + Environment.NewLine); sb.Append(" ,ADRESS2 = " + ExEscape.zRepStr(entity.adress2) + Environment.NewLine); sb.Append(" ,TEL = " + ExEscape.zRepStr(entity.tel) + Environment.NewLine); sb.Append(" ,FAX = " + ExEscape.zRepStr(entity.fax) + Environment.NewLine); sb.Append(" ,MAIL_ADRESS = " + ExEscape.zRepStr(entity.mail_adress) + Environment.NewLine); sb.Append(" ,MOBILE_TEL = " + ExEscape.zRepStr(entity.mobile_tel) + Environment.NewLine); sb.Append(" ,MOBILE_ADRESS = " + ExEscape.zRepStr(entity.mobile_adress) + Environment.NewLine); sb.Append(" ,URL = " + ExEscape.zRepStr(entity.url) + Environment.NewLine); sb.Append(" ,MEMO = " + ExEscape.zRepStr(entity.memo) + Environment.NewLine); sb.Append(" WHERE ID = " + companyId + Environment.NewLine); // COMPANY_ID #endregion db.ExecuteSQL(sb.ToString(), false); #region System Setting SQL sb.Length = 0; sb.Append("UPDATE SYS_M_SETTING " + Environment.NewLine); sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, ExCast.zCInt(personId), ipAdress, userId, 0)); sb.Append(" ,GROUP_DISPLAY_NAME = " + ExEscape.zRepStr(entity.group_display_name) + Environment.NewLine); sb.Append(" ,ID_FIGURE_SLIP_NO = " + entity.id_figure_slip_no + Environment.NewLine); sb.Append(" ,ID_FIGURE_CUSTOMER = " + entity.id_figure_customer + Environment.NewLine); sb.Append(" ,ID_FIGURE_PURCHASE = " + entity.id_figure_purchase + Environment.NewLine); sb.Append(" ,ID_FIGURE_GOODS = " + entity.id_figure_commodity + Environment.NewLine); sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID #endregion db.ExecuteSQL(sb.ToString(), false); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(Update)", ex); return(CLASS_NM + ".UpdateCompany(Update) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region Delete if (type == 2) { //#region Exist Data //try //{ // bool _ret = false; // _ret = DataExists.IsExistData(db, companyId, "", "SYS_M_COMPANY", "INVOICE_ID", ExCast.zNumZeroNothingFormat(Id), "ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String); // if (_ret == true) // { // return "得意先ID : " + Id + " は得意先マスタの請求IDにが使用されている為、削除できません。"; // } // _ret = DataExists.IsExistData(db, companyId, "", "T_ORDER_H", "Company_ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String); // if (_ret == true) // { // return "得意先ID : " + Id + " は受注データの得意先に使用されている為、削除できません。"; // } //} //catch (Exception ex) //{ // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(Exist Data)", ex); // return CLASS_NM + ".UpdateCompany(Exist Data) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; //} //#endregion //#region Update //try //{ // sb.Length = 0; // sb.Append("UPDATE SYS_M_COMPANY " + Environment.NewLine); // sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM, // ExCast.zCInt(personId), // ipAdress, // userId, // 1)); // sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID // sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID // db.ExecuteSQL(sb.ToString(), false); //} //catch (Exception ex) //{ // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(Delete)", ex); // return CLASS_NM + ".UpdateCompany(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; //} //#endregion } #endregion #region PG排他制御 if (type == 0 || type == 2) { try { DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(DelLockPg)", ex); return(CLASS_NM + ".UpdateCompany(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(CommitTransaction)", ex); return(CLASS_NM + ".UpdateCompany(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(DbClose)", ex); return(CLASS_NM + ".UpdateCompany(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { switch (type) { case 0: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Update, "ID:" + companyId.ToString()); break; case 1: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Insert, "ID:" + companyId.ToString()); break; case 2: svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Delete, "ID:" + companyId.ToString()); break; default: break; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCompany(Add Evidence)", ex); return(CLASS_NM + ".UpdateCompany(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Return return(""); #endregion }
public string UpdateStockInventory(string random, int type, string ymd, List <EntityStockInventory> entity) { #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; string personId = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); personId = ExCast.zCStr(HttpContext.Current.Session[ExSession.PERSON_ID]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { return(_message); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(認証処理)", ex); return(CLASS_NM + ".UpdateStockInventory : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString()); } #endregion #region Field StringBuilder sb = new StringBuilder(); DataTable dt; ExMySQLData db = null; string _Id = ""; int _classKbn = 0; long rec_cnt = 0; string str_message = ""; EntityInOutDeliveryH _entityInOutDeliveryH = new EntityInOutDeliveryH(); List <EntityInOutDeliveryD> _entityInOutDeliveryListD_Plus = new List <EntityInOutDeliveryD>(); List <EntityInOutDeliveryD> _entityInOutDeliveryListD_Minus = new List <EntityInOutDeliveryD>(); #endregion #region Databese Open try { db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR])); db.DbOpen(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(DbOpen)", ex); return(CLASS_NM + ".UpdateStockInventory(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region BeginTransaction try { db.ExBeginTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(BeginTransaction)", ex); return(CLASS_NM + ".UpdateStockInventory(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Update if (type == 0) { try { for (int i = 0; i <= entity.Count - 1; i++) { if (entity[i].exec_flg == true && entity[i].diff_number != 0) { #region Update Commodity Inventory try { DataCommodityInventory.UpdCommodityInventory(companyId, groupId, db, ExCast.zNumZeroNothingFormat(entity[i].commodity_id), entity[i].diff_number * -1, PG_NM, ExCast.zCInt(personId), ipAdress, userId); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSales(Update Commodity Inventory)", ex); return("UpdateSales(Update Commodity Inventory) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Set Entity InOutDelivery rec_cnt += 1; EntityInOutDeliveryD _entityInOutDeliveryD = new EntityInOutDeliveryD(); _entityInOutDeliveryD.rec_no = rec_cnt; _entityInOutDeliveryD.commodity_id = entity[i].commodity_id; _entityInOutDeliveryD.commodity_name = entity[i].commodity_name; _entityInOutDeliveryD.unit_id = 0; _entityInOutDeliveryD.enter_number = 0; _entityInOutDeliveryD.case_number = 0; if (entity[i].diff_number > 0) { _entityInOutDeliveryD.number = entity[i].diff_number; _entityInOutDeliveryListD_Minus.Add(_entityInOutDeliveryD); } else { _entityInOutDeliveryD.number = entity[i].diff_number * -1; _entityInOutDeliveryListD_Plus.Add(_entityInOutDeliveryD); } #endregion } } #region Update InOutDelivery try { svcInOutDelivery _svcInOutDelivery = new svcInOutDelivery(); if (_entityInOutDeliveryListD_Minus.Count > 0) { _entityInOutDeliveryH.in_out_delivery_ymd = ymd; _entityInOutDeliveryH.in_out_delivery_kbn = 2; // 入出庫区分:出庫 _entityInOutDeliveryH.in_out_delivery_proc_kbn = 4; // 入出庫処理区分:棚卸 _entityInOutDeliveryH.in_out_delivery_to_kbn = 1; // 入出庫先区分:グループ _entityInOutDeliveryH.update_person_id = ExCast.zCInt(personId); _entityInOutDeliveryH.group_id_to = groupId; for (int i = 0; i <= _entityInOutDeliveryListD_Minus.Count - 1; i++) { _entityInOutDeliveryH.sum_enter_number += _entityInOutDeliveryListD_Minus[i].enter_number; _entityInOutDeliveryH.sum_case_number += _entityInOutDeliveryListD_Minus[i].case_number; _entityInOutDeliveryH.sum_number += _entityInOutDeliveryListD_Minus[i].number; } // random // update type 1:Insert // procKbn 4:棚卸 // InOutDeliveryNo 入出庫番号 // CauseNo 元伝票番号 str_message = _svcInOutDelivery.UpdateInOutDeliveryExcExc(random, 1, 4, 0, 0, _entityInOutDeliveryH, _entityInOutDeliveryListD_Minus, null, null); if (str_message.IndexOf("Auto Insert success : ") == -1 && !string.IsNullOrEmpty(str_message)) { return("UpdateStockInventory(Update InOutDelivery) : " + str_message); } } _svcInOutDelivery = new svcInOutDelivery(); _entityInOutDeliveryH = null; _entityInOutDeliveryH = new EntityInOutDeliveryH(); if (_entityInOutDeliveryListD_Plus.Count > 0) { _entityInOutDeliveryH.in_out_delivery_ymd = ymd; _entityInOutDeliveryH.in_out_delivery_kbn = 1; // 入出庫区分:入庫 _entityInOutDeliveryH.in_out_delivery_proc_kbn = 4; // 入出庫処理区分:棚卸 _entityInOutDeliveryH.in_out_delivery_to_kbn = 1; // 入出庫先区分:グループ _entityInOutDeliveryH.update_person_id = ExCast.zCInt(personId); _entityInOutDeliveryH.group_id_to = groupId; for (int i = 0; i <= _entityInOutDeliveryListD_Plus.Count - 1; i++) { _entityInOutDeliveryH.sum_enter_number += _entityInOutDeliveryListD_Plus[i].enter_number; _entityInOutDeliveryH.sum_case_number += _entityInOutDeliveryListD_Plus[i].case_number; _entityInOutDeliveryH.sum_number += _entityInOutDeliveryListD_Plus[i].number; } // random // update type 1:Insert // procKbn 4:棚卸 // InOutDeliveryNo 入出庫番号 // CauseNo 元伝票番号 str_message = _svcInOutDelivery.UpdateInOutDeliveryExcExc(random, 1, 4, 0, 0, _entityInOutDeliveryH, _entityInOutDeliveryListD_Plus, null, null); if (str_message.IndexOf("Auto Insert success : ") == -1 && !string.IsNullOrEmpty(str_message)) { return("UpdateStockInventory(Update InOutDelivery) : " + str_message); } } } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(Update InOutDelivery)", ex); return("UpdateStockInventory(Update InOutDelivery) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(Insert)", ex); return(CLASS_NM + ".UpdateStockInventory(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } } #endregion #region PG排他制御 //try //{ // DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db); //} //catch (Exception ex) //{ // db.ExRollbackTransaction(); // CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(DelLockPg)", ex); // return CLASS_NM + ".UpdateStockInventory(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message; //} #endregion #region CommitTransaction try { db.ExCommitTransaction(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(CommitTransaction)", ex); return(CLASS_NM + ".UpdateStockInventory(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion #region Database Close try { db.DbClose(); } catch (Exception ex) { db.ExRollbackTransaction(); CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(DbClose)", ex); return(CLASS_NM + ".UpdateStockInventory(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } finally { db = null; } #endregion #region Add Evidence try { svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.DeleteAndInsert, ""); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(Add Evidence)", ex); return(CLASS_NM + ".UpdateStockInventory(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); } #endregion return(""); }
public EntityCompany GetCompany(string random) { EntityCompany entity; #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { entity = new EntityCompany(); entity.MESSAGE = _message; return(entity); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetCompany(認証処理)", ex); entity = new EntityCompany(); entity.MESSAGE = CLASS_NM + ".GetCompany : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();; return(entity); } #endregion StringBuilder sb; DataTable dt; ExMySQLData db; try { db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]), ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR])); sb = new StringBuilder(); #region SQL sb.Append("SELECT MT.* " + Environment.NewLine); sb.Append(" ,SS.ID_FIGURE_SLIP_NO " + Environment.NewLine); sb.Append(" ,SS.ID_FIGURE_CUSTOMER " + Environment.NewLine); sb.Append(" ,SS.ID_FIGURE_PURCHASE " + Environment.NewLine); sb.Append(" ,SS.ID_FIGURE_GOODS " + Environment.NewLine); sb.Append(" ,SS.GROUP_DISPLAY_NAME " + Environment.NewLine); sb.Append(" ,ES_YMD.YMD AS ES_YMD " + Environment.NewLine); sb.Append(" ,JC_YMD.YMD AS JC_YMD " + Environment.NewLine); sb.Append(" ,SA_YMD.YMD AS SA_YMD " + Environment.NewLine); sb.Append(" ,RP_YMD.YMD AS RP_YMD " + Environment.NewLine); sb.Append(" ,ES_CNT.CNT AS ES_CNT " + Environment.NewLine); sb.Append(" ,JC_CNT.CNT AS JC_CNT " + Environment.NewLine); sb.Append(" ,SA_CNT.CNT AS SA_CNT " + Environment.NewLine); sb.Append(" ,RP_CNT.CNT AS RP_CNT " + Environment.NewLine); sb.Append(" FROM SYS_M_COMPANY AS MT" + Environment.NewLine); #region Join // システム設定 sb.Append(" LEFT JOIN SYS_M_SETTING AS SS" + Environment.NewLine); sb.Append(" ON SS.COMPANY_ID = MT.ID" + Environment.NewLine); // 見積最終伝票入力日 sb.Append(" LEFT JOIN (SELECT COMPANY_ID" + Environment.NewLine); sb.Append(" , MAX(date_format(ESTIMATE_YMD , " + ExEscape.SQL_YMD + ")) AS YMD " + Environment.NewLine); sb.Append(" FROM T_ESTIMATE_H " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" GROUP BY COMPANY_ID) AS ES_YMD" + Environment.NewLine); sb.Append(" ON ES_YMD.COMPANY_ID = MT.ID" + Environment.NewLine); // 受注最終伝票入力日 sb.Append(" LEFT JOIN (SELECT COMPANY_ID" + Environment.NewLine); sb.Append(" , MAX(date_format(ORDER_YMD , " + ExEscape.SQL_YMD + ")) AS YMD " + Environment.NewLine); sb.Append(" FROM T_ORDER_H " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" GROUP BY COMPANY_ID) AS JC_YMD" + Environment.NewLine); sb.Append(" ON JC_YMD.COMPANY_ID = MT.ID" + Environment.NewLine); // 売上最終伝票入力日 sb.Append(" LEFT JOIN (SELECT COMPANY_ID" + Environment.NewLine); sb.Append(" , MAX(date_format(SALES_YMD , " + ExEscape.SQL_YMD + ")) AS YMD " + Environment.NewLine); sb.Append(" FROM T_SALES_H " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" GROUP BY COMPANY_ID) AS SA_YMD" + Environment.NewLine); sb.Append(" ON SA_YMD.COMPANY_ID = MT.ID" + Environment.NewLine); // 入金最終伝票入力日 sb.Append(" LEFT JOIN (SELECT COMPANY_ID" + Environment.NewLine); sb.Append(" , MAX(date_format(RECEIPT_YMD , " + ExEscape.SQL_YMD + ")) AS YMD " + Environment.NewLine); sb.Append(" FROM T_RECEIPT_H " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" GROUP BY COMPANY_ID) AS RP_YMD" + Environment.NewLine); sb.Append(" ON RP_YMD.COMPANY_ID = MT.ID" + Environment.NewLine); // 見積現在伝票件数 sb.Append(" LEFT JOIN (SELECT COMPANY_ID" + Environment.NewLine); sb.Append(" , COUNT(COMPANY_ID) AS CNT " + Environment.NewLine); sb.Append(" FROM T_ESTIMATE_H " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" GROUP BY COMPANY_ID) AS ES_CNT" + Environment.NewLine); sb.Append(" ON ES_CNT.COMPANY_ID = MT.ID" + Environment.NewLine); // 受注現在伝票件数 sb.Append(" LEFT JOIN (SELECT COMPANY_ID" + Environment.NewLine); sb.Append(" , COUNT(COMPANY_ID) AS CNT " + Environment.NewLine); sb.Append(" FROM T_ORDER_H " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" GROUP BY COMPANY_ID) AS JC_CNT" + Environment.NewLine); sb.Append(" ON JC_CNT.COMPANY_ID = MT.ID" + Environment.NewLine); // 売上現在伝票件数 sb.Append(" LEFT JOIN (SELECT COMPANY_ID" + Environment.NewLine); sb.Append(" , COUNT(COMPANY_ID) AS CNT " + Environment.NewLine); sb.Append(" FROM T_SALES_H " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" GROUP BY COMPANY_ID) AS SA_CNT" + Environment.NewLine); sb.Append(" ON SA_CNT.COMPANY_ID = MT.ID" + Environment.NewLine); // 入金現在伝票件数 sb.Append(" LEFT JOIN (SELECT COMPANY_ID" + Environment.NewLine); sb.Append(" , COUNT(COMPANY_ID) AS CNT " + Environment.NewLine); sb.Append(" FROM T_RECEIPT_H " + Environment.NewLine); sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" GROUP BY COMPANY_ID) AS RP_CNT" + Environment.NewLine); sb.Append(" ON RP_CNT.COMPANY_ID = MT.ID" + Environment.NewLine); #endregion sb.Append(" WHERE MT.ID = " + companyId + Environment.NewLine); sb.Append(" AND MT.DELETE_FLG = 0 " + Environment.NewLine); #endregion dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { entity = new EntityCompany(); // 排他制御 DataPgLock.geLovkFlg lockFlg; string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, companyId.ToString(), ipAdress, db, out lockFlg); if (strErr != "") { entity.MESSAGE = CLASS_NM + ".GetCompany : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr; } #region Set Entity entity.name = ExCast.zCStr(dt.DefaultView[0]["NAME"]); entity.kana = ExCast.zCStr(dt.DefaultView[0]["KANA"]); string _zip = ExCast.zCStr(dt.DefaultView[0]["ZIP_CODE"]); if (!string.IsNullOrEmpty(_zip) && ExCast.zCStr(_zip) != "0") { _zip = string.Format("{0:0000000}", ExCast.zCDbl(_zip)); entity.zip_code_from = _zip.Substring(0, 3); entity.zip_code_to = _zip.Substring(3, 4); } else { entity.zip_code_from = ""; entity.zip_code_to = ""; } entity.prefecture_id = ExCast.zCInt(dt.DefaultView[0]["PREFECTURE_ID"]); entity.city_id = ExCast.zCInt(dt.DefaultView[0]["CITY_ID"]); entity.town_id = ExCast.zCInt(dt.DefaultView[0]["TOWN_ID"]); entity.adress_city = ExCast.zCStr(dt.DefaultView[0]["ADRESS_CITY"]); entity.adress_town = ExCast.zCStr(dt.DefaultView[0]["ADRESS_TOWN"]); entity.adress1 = ExCast.zCStr(dt.DefaultView[0]["ADRESS1"]); entity.adress2 = ExCast.zCStr(dt.DefaultView[0]["ADRESS2"]); entity.tel = ExCast.zCStr(dt.DefaultView[0]["TEL"]); entity.fax = ExCast.zCStr(dt.DefaultView[0]["FAX"]); entity.mail_adress = ExCast.zCStr(dt.DefaultView[0]["MAIL_ADRESS"]); entity.mobile_tel = ExCast.zCStr(dt.DefaultView[0]["MOBILE_TEL"]); entity.mobile_adress = ExCast.zCStr(dt.DefaultView[0]["MOBILE_ADRESS"]); entity.url = ExCast.zCStr(dt.DefaultView[0]["URL"]); entity.group_display_name = ExCast.zCStr(dt.DefaultView[0]["GROUP_DISPLAY_NAME"]); entity.id_figure_slip_no = ExCast.zCInt(dt.DefaultView[0]["ID_FIGURE_SLIP_NO"]); entity.id_figure_customer = ExCast.zCInt(dt.DefaultView[0]["ID_FIGURE_CUSTOMER"]); entity.id_figure_purchase = ExCast.zCInt(dt.DefaultView[0]["ID_FIGURE_PURCHASE"]); entity.id_figure_commodity = ExCast.zCInt(dt.DefaultView[0]["ID_FIGURE_GOODS"]); entity.estimate_ymd = ExCast.zDateNullToDefault(dt.DefaultView[0]["ES_YMD"]); entity.order_ymd = ExCast.zDateNullToDefault(dt.DefaultView[0]["JC_YMD"]); entity.sales_ymd = ExCast.zDateNullToDefault(dt.DefaultView[0]["SA_YMD"]); entity.receipt_ymd = ExCast.zDateNullToDefault(dt.DefaultView[0]["RP_YMD"]); entity.purchase_order_ymd = ""; entity.purchase_ymd = ""; entity.cash_payment_ymd = ""; entity.produce_ymd = ""; entity.ship_ymd = ""; entity.estimate_cnt = ExCast.zCLng(dt.DefaultView[0]["ES_CNT"]); entity.order_cnt = ExCast.zCLng(dt.DefaultView[0]["JC_CNT"]); entity.sales_cnt = ExCast.zCLng(dt.DefaultView[0]["SA_CNT"]); entity.receipt_cnt = ExCast.zCLng(dt.DefaultView[0]["RP_CNT"]); entity.purchase_order_cnt = 0; entity.purchase_cnt = 0; entity.cash_payment_cnt = 0; entity.produce_cnt = 0; entity.ship_cnt = 0; entity.lock_flg = (int)lockFlg; entity.memo = ExCast.zCStr(dt.DefaultView[0]["MEMO"]); #endregion } else { entity = null; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetCompany", ex); entity = new EntityCompany(); entity.MESSAGE = CLASS_NM + ".GetCompany : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); } finally { db = null; } svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]), companyId, userId, ipAdress, sessionString, PG_NM, DataPgEvidence.geOperationType.Select, "ID:" + companyId.ToString()); return(entity); }
public void ProcessRequest(HttpContext context) { string errMsg = ""; #region Parameter Get string random = ""; string upLoadFileName = ""; int upLoadFileKbn = 0; try { random = context.Request.QueryString["random"]; upLoadFileName = context.Request.QueryString["upLoadFileName"]; upLoadFileKbn = ExCast.zCInt(context.Request.QueryString["upLoadFileKbn"]); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Parameter Get)", ex); errMsg = CLASS_NM + ".Page_Load(Parameter Get) : 予期せぬエラーが発生しました" + Environment.NewLine + ex.Message; } #endregion #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; if (string.IsNullOrEmpty(errMsg)) { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(認証処理) : 認証に失敗しました。" + Environment.NewLine + _message); return; } } #endregion #region UpLoad File Save string dir = ""; try { if (string.IsNullOrEmpty(errMsg)) { string date = ""; string time = ""; string millisecond = ""; DateTime now = DateTime.Now; date = now.ToString("yyyyMMdd"); time = now.ToString("HHmmss"); millisecond = now.Millisecond.ToString(); dir = date + time + millisecond; Byte[] buffer = null; buffer = new Byte[context.Request.InputStream.Length]; context.Request.InputStream.Read(buffer, 0, buffer.Length); if (upLoadFileKbn == 0) { if (!System.IO.Directory.Exists(CommonUtl.gstrFileUpLoadDir + dir)) { System.IO.Directory.CreateDirectory(CommonUtl.gstrFileUpLoadDir + dir); } using (FileStream fs = new FileStream(CommonUtl.gstrFileUpLoadDir + dir + "\\" + upLoadFileName, FileMode.Create)) { fs.Write(buffer, 0, buffer.Length); fs.Close(); } } else if (upLoadFileKbn == 1) { if (!System.IO.Directory.Exists(CommonUtl.gstrFileUpLoadDutiesDir + dir)) { System.IO.Directory.CreateDirectory(CommonUtl.gstrFileUpLoadDutiesDir + dir); } using (FileStream fs = new FileStream(CommonUtl.gstrFileUpLoadDutiesDir + dir + "\\" + upLoadFileName, FileMode.Create)) { fs.Write(buffer, 0, buffer.Length); fs.Close(); } } else { errMsg = CLASS_NM + ".Page_Load(UpLoad File Save) : upLoadFileKbnが不正です。"; } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(UpLoad File Save)", ex); errMsg = CLASS_NM + ".Page_Load(UpLoad File Save) : 予期せぬエラーが発生しました" + Environment.NewLine + ex.Message; } #endregion #region Response string ret_Msg = ""; try { context.Response.ContentType = "application/octet-stream"; context.Response.AppendHeader("Content-Disposition", "attachment; filename="); context.Response.Flush(); if (errMsg != "") { ret_Msg = "error message start ==>" + errMsg; } else { ret_Msg = "success file upload ==>" + dir; } context.Response.Write(ret_Msg); context.Response.Flush(); context.Response.Close(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".Page_Load(Response)", ex); } #endregion }
public EntityReport ReportOut(string random, string rptKbn, string pgId, string parameters) { EntityReport entity; EntityReportSetting entitySetting; #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; int reportSizeUser = 0; int idFigureCommodity = 0; int idFigureCustomer = 0; int idFigurePurchase = 0; int idFigureSlipNo = 0; int rpTotalAuthorityKbn = 0; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); reportSizeUser = ExCast.zCInt(HttpContext.Current.Session[ExSession.REPORT_SAVE_SIZE_USER]); idFigureCommodity = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_GOODS]); idFigureCustomer = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_CUSTOMER]); idFigurePurchase = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_PURCHASE]); idFigureSlipNo = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_SLIP_NO]); rpTotalAuthorityKbn = ExCast.zCInt(HttpContext.Current.Session[ExSession.REPORT_TOTAL_AUTHORITY_KBN]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { entity = new EntityReport(); entity.MESSAGE = _message; return(entity); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".ReportOut(認証処理)", ex); entity = new EntityReport(); entity.MESSAGE = CLASS_NM + ".ReportOut : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString(); return(entity); } #endregion ExMySQLData db = ExSession.GetSessionDb(ExCast.zCInt(userId), sessionString); try { #region Get Report Setting entitySetting = GetReportSetting(random, pgId); if (entitySetting == null) { entitySetting = new EntityReportSetting(); entitySetting.user_id = ExCast.zCInt(userId); entitySetting.pg_id = pgId; entitySetting.group_id_from = ExCast.zCInt(groupId).ToString(); entitySetting.group_id_to = ExCast.zCInt(groupId).ToString(); } else if (entitySetting != null) { if (!string.IsNullOrEmpty(entitySetting.MESSAGE)) { entitySetting = new EntityReportSetting(); entitySetting.user_id = ExCast.zCInt(userId); entitySetting.pg_id = pgId; entitySetting.group_id_from = ExCast.zCInt(groupId).ToString(); entitySetting.group_id_to = ExCast.zCInt(groupId).ToString(); } else { if (ExCast.zCInt(entitySetting.group_id_from) == 0 && ExCast.zCInt(entitySetting.group_id_to) == 0) { entitySetting.group_id_from = ExCast.zCInt(groupId).ToString(); entitySetting.group_id_to = ExCast.zCInt(groupId).ToString(); } } } if (rpTotalAuthorityKbn < 2) { entitySetting.group_id_from = ExCast.zCInt(groupId).ToString(); entitySetting.group_id_to = ExCast.zCInt(groupId).ToString(); } #endregion entity = new EntityReport(); DataReport.geReportKbn kbn = (DataReport.geReportKbn)ExCast.zCInt(rptKbn); ExReportManeger rptMgr = new ExReportManeger(); rptMgr.idFigureCommodity = idFigureCommodity; rptMgr.idFigureCustomer = idFigureCustomer; rptMgr.idFigurePurchase = idFigurePurchase; rptMgr.idFigureSlipNo = idFigureSlipNo; rptMgr.entitySetting = entitySetting; rptMgr.rptKbn = kbn; #region Report FilePath Setting bool _ret = rptMgr.GetReportFilePath(pgId, companyId, userId); if (_ret == false) { entity.MESSAGE = CommonUtl.gstrErrMsg; return(entity); } entity.downLoadFilePath = rptMgr.reportFilePath; entity.downLoadFileName = rptMgr.reportFileName; entity.downLoadFileSize = rptMgr.reportFileSize.ToString(); entity.downLoadUrl = CommonUtl.gstrMainUrl + rptMgr.reportDir; #endregion DataSet ds = db.GetDataSet(rptMgr.ReportSQL(pgId, companyId, groupId, parameters), rptMgr.GetPGIDXsd(pgId)); #region Export xsd System.IO.StreamWriter xmlSW = null; try { xmlSW = new System.IO.StreamWriter(CommonUtl.gstrReportTemp + rptMgr.GetPGIDXsd(pgId) + ".xsd"); ds.WriteXmlSchema(xmlSW); xmlSW.Close(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".WriteXmlSchema", ex); } finally { if (xmlSW != null) { xmlSW.Dispose(); xmlSW = null; } } #endregion if (ds.Tables[0].Rows.Count == 0) { entity.MESSAGE = "データが存在しません。"; entity.ret = false; return(entity); } string _fileType = ""; string _DownloadType = ""; switch (kbn) { case DataReport.geReportKbn.OutPut: _fileType = "PDF"; _DownloadType = "出力"; if (rptMgr.ReportToPdf(ds, pgId) == true) { entity.ret = true; } else { entity.MESSAGE = CommonUtl.gstrErrMsg; entity.ret = false; } break; case DataReport.geReportKbn.Download: _fileType = "PDF"; _DownloadType = "ダウンロード"; if (rptMgr.ReportToPdf(ds, pgId) == true) { entity.ret = true; } else { entity.MESSAGE = CommonUtl.gstrErrMsg; entity.ret = false; } break; case DataReport.geReportKbn.Csv: _fileType = "CSV"; _DownloadType = "ダウンロード"; if (rptMgr.DataTableToCsv(ds.Tables[0]) == true) { entity.ret = true; } else { entity.MESSAGE = CommonUtl.gstrErrMsg; entity.ret = false; } break; default: break; } //entity.downLoadFilePath = @"d:\HostingSpaces\Users\EW20121725\Sales.system-innovation.net\wwwroot\temp\顧客マスタ一覧.csv"; //System.IO.FileInfo fi = new System.IO.FileInfo(entity.downLoadFilePath); //entity.downLoadFileSize = fi.Length.ToString(); if (reportSizeUser < ExCast.zCDbl(entity.downLoadFileSize) / 1000000) { entity.MESSAGE = _fileType + "ファイルのサイズが" + reportSizeUser.ToString() + "Mバイトを超える為、" + _DownloadType + "できません。"; return(entity); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".ReportOut", ex); entity = new EntityReport(); entity.MESSAGE = CLASS_NM + ".ReportOut : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); return(entity); } return(entity); }