public List<EntityMstList> GetSupplierList(string random, string CustomerID, string ID, string Name, string Kana) { List<EntityMstList> objList = new List<EntityMstList>(); #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 != "") { EntityMstList entity = new EntityMstList(); entity.MESSAGE = _message; objList.Add(entity); return objList; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetSupplierList(認証処理)", ex); EntityMstList entity = new EntityMstList(); entity.MESSAGE = "認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString(); objList.Add(entity); return objList; } #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 SR.* " + Environment.NewLine); sb.Append(" FROM M_SUPPLIER AS SR" + Environment.NewLine); sb.Append(" WHERE SR.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND SR.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND SR.COMPANY_ID = " + companyId + Environment.NewLine); sb.Append(" AND SR.CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerID)) + Environment.NewLine); if (ID != "") { sb.Append(" AND SR.ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(ID)) + Environment.NewLine); } if (Name != "") { sb.Append(" AND SR.NAME LIKE '" + ExEscape.zRepStrNoQuota(Name) + "%'" + Environment.NewLine); } if (Kana != "") { sb.Append(" AND SR.KANA LIKE '" + ExEscape.zRepStrNoQuota(Kana) + "%'" + Environment.NewLine); } sb.Append(" ORDER BY SR.ID2 "); sb.Append(" ,SR.ID" + Environment.NewLine); sb.Append(" LIMIT 0, 1000"); #endregion dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { objList.Add(new EntityMstList(ExCast.zCStr(dt.DefaultView[i]["ID"]), ExCast.zCStr(dt.DefaultView[i]["CUSTOMER_ID"]), ExCast.zCStr(dt.DefaultView[i]["NAME"]) )); } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetSupplierList", ex); } finally { db = null; } return objList; }
public List<EntityMstList> GetUserList(string random, string ID, string Name, string Kana) { List<EntityMstList> objList = new List<EntityMstList>(); #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 != "") { EntityMstList entity = new EntityMstList(); entity.MESSAGE = _message; objList.Add(entity); return objList; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetGroupList(認証処理)", ex); EntityMstList entity = new EntityMstList(); entity.MESSAGE = "認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString(); objList.Add(entity); return objList; } #endregion StringBuilder sb; DataTable dt; try { sb = new StringBuilder(); #region SQL sb.Append("SELECT MT.* " + Environment.NewLine); sb.Append(" FROM SYS_M_USER AS MT" + Environment.NewLine); sb.Append(" WHERE MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.DISPLAY_FLG = 1 " + Environment.NewLine); if (ID != "") { sb.Append(" AND MT.LOGIN_ID = " + ExEscape.zRepStr(ID) + Environment.NewLine); } if (Name != "") { sb.Append(" AND MT.NAME LIKE '" + ExEscape.zRepStrNoQuota(Name) + "%'" + Environment.NewLine); } sb.Append(" ORDER BY MT.LOGIN_ID" + Environment.NewLine); sb.Append(" LIMIT 0, 1000"); #endregion dt = CommonUtl.gMySqlDt.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { EntityMstList mst = new EntityMstList(ExCast.zCStr(dt.DefaultView[i]["LOGIN_ID"]), ExCast.zCStr(dt.DefaultView[i]["LOGIN_ID"]), ExCast.zCStr(dt.DefaultView[i]["NAME"]) ); mst.ATTRIBUTE1 = ExCast.zCStr(dt.DefaultView[i]["ID"]); objList.Add(mst); } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetUserList", ex); } return objList; }
public List<EntityMstList> GetPaymentBalanceList(string random, string ID, string Name) { List<EntityMstList> objList = new List<EntityMstList>(); #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 != "") { EntityMstList entity = new EntityMstList(); entity.MESSAGE = _message; objList.Add(entity); return objList; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetSalesBalanceList(認証処理)", ex); EntityMstList entity = new EntityMstList(); entity.MESSAGE = "認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString(); objList.Add(entity); return objList; } #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(" ,CG.NAME " + Environment.NewLine); sb.Append(" FROM M_PAYMENT_CREDIT_BALANCE AS MT" + Environment.NewLine); // 会社グループ sb.Append(" LEFT JOIN SYS_M_COMPANY_GROUP AS CG" + Environment.NewLine); sb.Append(" ON CG.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND CG.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine); sb.Append(" AND CG.ID = MT.GROUP_ID" + Environment.NewLine); sb.Append(" WHERE MT.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND MT.DISPLAY_FLG = 1 " + Environment.NewLine); sb.Append(" AND MT.COMPANY_ID = " + companyId + Environment.NewLine); if (ID != "") { sb.Append(" AND MT.ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(ID)) + Environment.NewLine); } //if (Name != "") //{ // sb.Append(" AND MT.NAME LIKE '" + ExEscape.zRepStrNoQuota(Name) + "%'" + Environment.NewLine); //} sb.Append(" ORDER BY CG.ID" + Environment.NewLine); #endregion dt = db.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { objList.Add(new EntityMstList(ExCast.zCStr(dt.DefaultView[i]["NAME"]), ExCast.zCStr(dt.DefaultView[i]["NAME"]), String.Format("{0,12:#,##0}", ExCast.zCDbl(dt.DefaultView[i]["PAYMENT_CREDIT_PRICE"])) )); } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetPaymentBalanceList", ex); } return objList; }
public List<EntityMstList> GetZipList(string random, string zipFrom, string zipTo) { List<EntityMstList> objList = new List<EntityMstList>(); #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 != "") { EntityMstList entity = new EntityMstList(); entity.MESSAGE = _message; objList.Add(entity); return objList; } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetZipList(認証処理)", ex); EntityMstList entity = new EntityMstList(); entity.MESSAGE = "認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString(); objList.Add(entity); return objList; } #endregion StringBuilder sb; DataTable dt; try { sb = new StringBuilder(); #region SQL sb.Append("SELECT ZP.* " + Environment.NewLine); sb.Append(" FROM SYS_M_ZIP AS ZP" + Environment.NewLine); sb.Append(" WHERE ZP.DELETE_FLG = 0 " + Environment.NewLine); sb.Append(" AND ZP.DISPLAY_FLG = 1 " + Environment.NewLine); if (zipFrom != "" && zipTo != "") { sb.Append(" AND ZP.ZIP = " + ExEscape.zRepStr(ExCast.zCInt(zipFrom).ToString() + zipTo) + Environment.NewLine); } else if (zipFrom != "") { sb.Append(" AND ZP.ZIP LIKE '" + ExEscape.zRepStrNoQuota(ExCast.zCInt(zipFrom)) + "%'" + Environment.NewLine); } else if (zipTo != "") { sb.Append(" AND ZP.ZIP LIKE '%" + ExEscape.zRepStrNoQuota(zipTo) + "'" + Environment.NewLine); } sb.Append(" ORDER BY ZIP" + Environment.NewLine); sb.Append(" LIMIT 0, 1000"); #endregion dt = CommonUtl.gMySqlDt.GetDataTable(sb.ToString()); if (dt.DefaultView.Count > 0) { for (int i = 0; i <= dt.DefaultView.Count - 1; i++) { EntityMstList mst = new EntityMstList(ExCast.zCStr(dt.DefaultView[i]["ZIP"]), ExCast.zCStr(dt.DefaultView[i]["ZIP"]), ExCast.zCStr(dt.DefaultView[i]["PREDECTURE_NAME"]) + ExCast.zCStr(dt.DefaultView[i]["CITY_NAME"]) + ExCast.zCStr(dt.DefaultView[i]["TOWN_NAME"])); mst.ATTRIBUTE1 = ExCast.zCStr(dt.DefaultView[i]["PREDECTURE_NAME"]); mst.ATTRIBUTE2 = ExCast.zCStr(dt.DefaultView[i]["CITY_NAME"]); mst.ATTRIBUTE3 = ExCast.zCStr(dt.DefaultView[i]["TOWN_NAME"]); objList.Add(mst); } } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".GetZipList", ex); } return objList; }