public int UpdateCompany(EntityCompany entCompany)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@CompanyCode", DbType.String, entCompany.CompanyCode);
Commons.ADDParameter(ref lstParam, "@CompanyName", DbType.String, entCompany.CompanyName);
Commons.ADDParameter(ref lstParam, "@Address", DbType.String, entCompany.Address);
Commons.ADDParameter(ref lstParam, "@PhoneNo", DbType.String, entCompany.PhoneNo);
Commons.ADDParameter(ref lstParam, "@MobileNo", DbType.String, entCompany.MobileNo);
Commons.ADDParameter(ref lstParam, "@VATCSTNo", DbType.String, entCompany.VATCSTNo);
Commons.ADDParameter(ref lstParam, "@ExciseNo", DbType.String, entCompany.ExciseNo);
Commons.ADDParameter(ref lstParam, "@Email", DbType.String, entCompany.Email);
Commons.ADDParameter(ref lstParam, "@ServiceTaxNo", DbType.String, entCompany.ServiceTaxNo);
Commons.ADDParameter(ref lstParam, "@ChangeBy", DbType.String, entCompany.ChangeBy);
cnt = mobjDataAcces.ExecuteQuery("sp_UpdateCompany", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("CompanyBLL - UpdateCompany(EntityCompany entCompany)", ex);
}
return(cnt);
}
public EntityCompany GetCompany(string quert)
{
var str = File.ReadAllText("temp.txt");
var doc = new HtmlDocument();
doc.LoadHtml(str);
RemoveControlsByClass(doc, "headerLogo");
RemoveControlsByClass(doc, "phoneModalContainer");
RemoveControlsByClass(doc, "modalContainer");
var a = doc.DocumentNode.Descendants(0).Where(n => n.Id == "preloadINN").First();
a.ParentNode.RemoveChild(a);
a = doc.DocumentNode.Descendants(0).Where(n => n.Name == "nav").First();
a.ParentNode.RemoveChild(a);
var company = new EntityCompany()
{
Html = doc.DocumentNode.OuterHtml
};
return(company);
}
static void Main(string[] args)
{
EntityCompany company = new EntityCompany();
company.Name = "asdf";
company.Number = "1ads23";
company.CreatedDate = DateTime.Now;
SqlHelper sh = new SqlHelper();
//long id = sh.Insert<EntityCompany>(company);
ConvertToSqlExpressionVisitor visitor = new ConvertToSqlExpressionVisitor();
//List<long> ids = new List<long>();
//ids.Add(3);
//ids.Add(4);
//ids.Add(5);
//Expression<Func<EntityCompany, bool>> expression = c => (c.Id > 1
// && c.Id < 10
// || c.Id == 5)
// && c.Number.StartsWith("1")
// && (c.Number.EndsWith("2")
// || c.Number.Contains("3"))
// && ids.Contains(c.Id);
Expression <Func <EntityCompany, bool> > expression = r => r.Id > 2 && r.Id < 10 && r.Number.Contains("1");
var list = sh.Find <EntityCompany>(expression);
Console.WriteLine(list.Count);
Console.Read();
}
public EntityCompany GetCompany(EntityCompany entCompany)
{
EntityCompany ent = (from tbl in objData.tblCompanyMasters
where tbl.VATCSTNo.Equals(entCompany.VATCSTNo)
select new EntityCompany {
VATCSTNo = tbl.VATCSTNo
}).FirstOrDefault();
return(ent);
}
public EntityResultSearch SearchCompany(EntityCompany company, string key)
{
var url = $"search/legal?" +
$"token={key}" +
$"®ion={company?.Region}" +
$"&name={company?.Name}" +
(string.IsNullOrEmpty(company?.Address) ? "" : $"&address={company?.Address}");
return(GetResultSearch(url));
}
/// <summary>
/// 插入行业信息
/// </summary>
/// <param name="entity"></param>
public async Task InsertCompanyInfoSync(EntityCompany entity)
{
var model = new TableCompany();
entity.FoundedTime = entity.FoundedTime ?? DateTime.Now;
entity.IssureTime = entity.IssureTime ?? DateTime.Now;
model = Mapper.Map <EntityCompany, TableCompany>(entity);
model.Id = Utils.GetNewId();
var companyRep = GetRepositoryInstance <TableCompany>();
await companyRep.InsertAsync(model);
}
public int UpdateCompanyTable(EntityCompany entity)
{
string SqlStr = "";
SqlStr = "update tc_company set ";
SqlStr += " company_name = '" + entity.Company_name.Trim() + "' ";
SqlStr += ",company_registered_address = '" + entity.Company_registered_address.Trim() + "' ";
SqlStr += ",company_rel_address = '" + entity.Company_rel_address.Trim() + "' ";
SqlStr += ",company_storage_address = '" + entity.Company_storage_address.Trim() + "' ";
SqlStr += ",company_artificial_person = '" + entity.Company_artificial_person.Trim() + "' ";
SqlStr += ",company_principal = '" + entity.Company_principal.Trim() + "' ";
SqlStr += ",company_business_type = '" + entity.Company_business_type.Trim() + "' ";
SqlStr += ",company_licence = '" + entity.Company_licence.Trim() + "' ";
SqlStr += ",company_business_licence = '" + entity.Company_business_licence.Trim() + "' ";
SqlStr += ",company_tel = '" + entity.Company_tel.Trim() + "' ";
SqlStr += ",company_fax = '" + entity.Company_fax.Trim() + "' ";
SqlStr += ",company_postal_code = '" + entity.Company_postal_code.Trim() + "' ";
SqlStr += ",company_bank = '" + entity.Company_bank.Trim() + "' ";
SqlStr += ",company_bank_num = '" + entity.Company_bank_num.Trim() + "' ";
SqlStr += ",company_tariff_num = '" + entity.Company_tariff_num.Trim() + "' ";
SqlStr += ",company_quality_persion = '" + entity.Company_quality_persion.Trim() + "' ";
SqlStr += ",company_business_scope = '" + entity.Company_business_scope.Trim() + "' ";
SqlStr += ",company_mobile = '" + entity.Company_mobile.Trim() + "' ";
SqlStr += ",company_style = '" + entity.Company_style.Trim() + "' ";
SqlStr += " where company_code= '" + entity.Company_code.Trim() + "' ";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
ExcuteSql(sqlCommand);
return(Constants.SystemConfig.SERVER_SUCCESS);
}
public async Task <ResponseModel> UpdateCompanyInfo(EntityCompany entityCompany)
{
if (string.IsNullOrEmpty(entityCompany.Id))
{
return(Fail(ErrorCodeEnum.ParamIsNullArgument));
}
await ICompanyService.UpdateCompanyInfo(entityCompany);
return(Success("保存成功"));
}
public async Task <ResponseModel> AddCompanyInfo(EntityCompany entityCompany)
{
var result = ICompanyService.GetCompanyInfoByName(entityCompany.CompanyName);
if (result.Result != null)
{
return(Fail(ErrorCodeEnum.CompanyAlreadyExist));
}
await ICompanyService.InsertCompanyInfoSync(entityCompany);
return(Success("保存成功"));
}
internal static Company Map(EntityCompany entity)
{
return(new Company
{
CompanyId = entity.CompanyId,
CompanyGuid = entity.CompanyGuid,
Name = entity.Name,
Description = entity.Description,
CompanyVatRegNo = entity.CompanyVatRegNo,
CreatedOn = entity.CreatedOn,
CreatedBy = entity.CreatedBy
});
}
public int DeleteCompany(EntityCompany entCompany)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@CompanyCode", DbType.String, entCompany.CompanyCode);
cnt = mobjDataAcces.ExecuteQuery("sp_DeleteCompany", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("CompanyBLL - DeleteCompany(EntityCompany entCompany)", ex);
}
return(cnt);
}
public EntityCompany GetCompany(string quert)
{
EntityCompany company;
var str = _httpService.RequestGet(quert, HttpService.EnumContentType.Html);
var doc = new HtmlDocument();
doc.LoadHtml(str);
RemoveControl(doc);
company = new EntityCompany()
{
Html = doc.DocumentNode.OuterHtml
};
return(company);
}
public override void DataSelect(int intKbn, object objList)
{
switch ((ExWebService.geWebServiceCallKbn)intKbn)
{
case _GetWebServiceCallKbn:
// 更新
if (objList != null)
{
_entity = (EntityCompany)objList;
if (_entity.message != "" && _entity.message != null)
{
//btnF12_Click(null, null);
}
else
{
// バインド反映
SetBinding();
if (_entity._lock_flg == 0)
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Upd;
}
else
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Sel;
}
before_intidFigureSlipNo = _entity._id_figure_slip_no;
before_intidFigureCustomer = _entity._id_figure_customer;
before_intidFigurePurchase = _entity._id_figure_purchase;
before_intidFigureCommodity = _entity._id_figure_commodity;
}
}
else
{
//btnF12_Click(null, null);
}
ExBackgroundWorker.DoWork_Focus(this.txtName, 10);
break;
default:
break;
}
}
public async Task UpdateCompanyInfo(EntityCompany entity)
{
var model = new TableCompany();
model = Mapper.Map <EntityCompany, TableCompany>(entity);
model.Id = entity.Id;
var companyRep = GetRepositoryInstance <TableCompany>();
companyRep.Update <TableCompany>(model, companyInfo => new
{
companyInfo.CompanyName,
companyInfo.Provice,
companyInfo.ProvCode,
companyInfo.City,
companyInfo.CityCode,
companyInfo.County,
companyInfo.CountyCode,
companyInfo.AddressDetail,
companyInfo.Longitude,
companyInfo.Latitude,
companyInfo.Industry,
companyInfo.Economy,
companyInfo.CompanyDetail,
companyInfo.ZipCode,
companyInfo.FoundedTime,
companyInfo.IssureTime,
companyInfo.IndustryCode,
companyInfo.Owner,
companyInfo.CompanyScale,
companyInfo.CompanyIncome,
companyInfo.ChiefSafeyName,
companyInfo.ChiefSafeyPhone,
companyInfo.ViceSafeyName,
companyInfo.ViceSafeyPhone,
companyInfo.OnDutyPhone,
companyInfo.EmergencyPhone,
companyInfo.RiskLevel
});
}
public int InsertCompanyRow(EntityCompany entity)
{
string SqlStr = "";
SqlStr = "insert into tc_company(company_code,Company_name,Company_registered_address,Company_rel_address,"
+ " Company_storage_address,Company_artificial_person,Company_principal,Company_business_type,Company_licence,Company_business_licence,"
+ "Company_tel,Company_fax,Company_postal_code,Company_bank,"
+ "Company_bank_num,Company_tariff_num,Company_mobile,Company_quality_persion,Company_business_scope,Company_style)";
SqlStr += " values('" + entity.Company_code.Trim() + "','" + entity.Company_name.Trim() + "','" + entity.Company_registered_address.Trim() + "','"
+ entity.Company_rel_address.Trim() + "','" + entity.Company_storage_address.Trim() + "','"
+ entity.Company_artificial_person.Trim() + "','" + entity.Company_principal.Trim() + "','"
+ entity.Company_business_type.Trim() + "','" + entity.Company_licence.Trim() + "','" + entity.Company_business_licence.Trim() + "','"
+ entity.Company_tel.Trim() + "','" + entity.Company_fax.Trim() + "','" + entity.Company_postal_code.Trim() + "','" + entity.Company_bank.Trim() + "','"
+ entity.Company_bank_num.Trim() + "','" + entity.Company_tariff_num.Trim() + "','" + entity.Company_mobile.Trim() + "','" + entity.Company_quality_persion.Trim() + "','" + entity.Company_business_scope.Trim() + "','" + entity.Company_style.Trim() + "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
ExcuteSql(sqlCommand);
return(Constants.SystemConfig.SERVER_SUCCESS);
}
public override void DataSelect(int intKbn, object objList)
{
switch ((ExWebService.geWebServiceCallKbn)intKbn)
{
case _GetWebServiceCallKbn:
// 更新
if (objList != null)
{
_entity = (EntityCompanyGroup)objList;
if (_entity.message != "" && _entity.message != null)
{
this.utlID.txtID.Text = "";
ExBackgroundWorker.DoWork_Focus(this.utlID, 10);
return;
}
else
{
// バインド反映
SetBinding();
if (_entity._lock_flg == 0)
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Upd;
}
else
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Sel;
}
}
}
// 新規
else
{
_entity = new EntityCompanyGroup();
SetBinding();
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.New;
}
this.utlID.txtID_IsReadOnly = true;
ExBackgroundWorker.DoWork_Focus(this.txtName, 10);
break;
case ExWebService.geWebServiceCallKbn.GetCompany:
// 更新
if (objList != null)
{
EntityCompany entityCompany = (EntityCompany)objList;
if (string.IsNullOrEmpty(entityCompany.message))
{
_entity._name = entityCompany._name;
_entity._kana = entityCompany._kana;
_entity._zip_code_from = entityCompany._zip_code_from;
_entity._zip_code_to = entityCompany._zip_code_to;
_entity._adress_city = entityCompany._adress_city;
_entity._adress_town = entityCompany._adress_town;
_entity._adress1 = entityCompany._adress1;
_entity._adress2 = entityCompany._adress2;
_entity._tel = entityCompany._tel;
_entity._fax = entityCompany._fax;
_entity._mail_adress = entityCompany._mail_adress;
_entity._mobile_tel = entityCompany._mobile_tel;
_entity._mobile_adress = entityCompany._mobile_adress;
_entity._url = entityCompany._url;
SetBinding();
return;
}
}
break;
default:
break;
}
}
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 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
}
private void btnCommit_Click(object sender, EventArgs e)
{
//判断非法字符
foreach (Control control in this.panel1.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
if (txtCompanyName.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("企业名称不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCompanyName.Focus();
return;
}
if (Util.CheckCompanyName(txtCompanyName.Text.Trim()))
{
MessageBox.Show("企业名称不能包含特殊字符！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCompanyName.Focus();
return;
}
if (txtBusinessLicence.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("营业执照不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtBusinessLicence.Focus();
return;
}
if (txtLicence.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("许可证编号不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtLicence.Focus();
return;
}
if (Util.CheckCompanyName(txtLicence.Text.Trim()))
{
MessageBox.Show("许可证编号不能包含特殊字符！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtLicence.Focus();
return;
}
companyEntity = new EntityCompany();
companyEntity.Company_name = txtCompanyName.Text;
companyEntity.Company_registered_address = txtRegisteredAddress.Text;
companyEntity.Company_rel_address = txtRelAddress.Text;
companyEntity.Company_business_licence = txtBusinessLicence.Text;
companyEntity.Company_licence = txtLicence.Text;
companyEntity.Company_artificial_person = txtArtificialPerson.Text;
companyEntity.Company_principal = txtPrincipal.Text;
companyEntity.Company_business_type = comboxBusinessType.Text;
companyEntity.Company_storage_address = txtStorageAddress.Text;
companyEntity.Company_postal_code = txtPostalCode.Text;
companyEntity.Company_fax = txtFax.Text;
companyEntity.Company_tel = txtTel.Text;
companyEntity.Company_bank = txtBank.Text;
companyEntity.Company_bank_num = txtBankNum.Text;
companyEntity.Company_tariff_num = txtTariffNum.Text;
companyEntity.Company_business_scope = txt_company_business_scope.Text;
companyEntity.Company_mobile = txtMobile.Text;
companyEntity.Company_quality_persion = txt_company_quality_persion.Text;
companyEntity.Company_style = cmb_company_style.Text;
try
{
dataAccess = new DataAccess();
dataAccess.Open();
if (dataType == DataType.Insert)
{
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
companyEntity.Company_code = primaryKey.MakeCode("公司");
companyCode = companyEntity.Company_code;
GetData getData = new GetData(dataAccess.Connection);
//取得结果符
result = getData.InsertCompanyRow(companyEntity);
dataType = DataType.Update;
}
else if (dataType == DataType.Update)
{
//打开事务
dataAccess.BeginTransaction();
companyEntity.Company_code = companyCode;
//取得操作类
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateCompanyTable(companyEntity);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
MessageBox.Show(ex.Message);
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
if (result == 0)
{
MessageBox.Show("数据已保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (result == -1)
{
MessageBox.Show("数据提交失败,请检查数据库是否打开，添加信息是否正确！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void GetCompany()
{
try
{
objCompany = null; // 初期化
svcCompanyClient svc = new svcCompanyClient();
svc.GetCompanyCompleted += new EventHandler<GetCompanyCompletedEventArgs>(this.GetCompanyCompleted);
svc.GetCompanyAsync(Common.gstrSessionString);
}
catch (Exception ex)
{
this.ProcessingDlgClose();
ExMessageBox.Show(CLASS_NM + ".GetCompany" + Environment.NewLine + ex.ToString(), "エラー確認");
}
}
private void GetCompanyCompleted(Object sender, GetCompanyCompletedEventArgs e)
{
try
{
objCompany = e.Result;
if (DialogCloseFlg == geDialogCloseFlg.Yes & win != null)
{
win.Close();
win = null;
}
if (objCompany != null)
{
if (objCompany.message != "" && objCompany.message != null)
{
// 認証失敗
ExMessageBox.Show(objCompany.message);
objPerent.DataSelect((int)geWebServiceCallKbn.GetCompany, (object)objCompany);
}
else
{
// 認証成功
objPerent.DataSelect((int)geWebServiceCallKbn.GetCompany, (object)objCompany);
}
}
else
{
objPerent.DataSelect((int)geWebServiceCallKbn.GetCompany, null);
}
}
catch (Exception ex)
{
this.ProcessingDlgClose();
ExMessageBox.Show(CLASS_NM + ".GetCompanyCompleted" + Environment.NewLine + ex.ToString(), "エラー確認");
}
finally
{
if (DialogCloseFlg == geDialogCloseFlg.Yes & win != null)
{
win.Close();
win = null;
}
}
}
private void UpdateCompany(int type, EntityCompany entity)
{
try
{
svcCompanyClient svc = new svcCompanyClient();
svc.UpdateCompanyCompleted += new EventHandler<UpdateCompanyCompletedEventArgs>(this.UpdateCompanyCompleted);
svc.UpdateCompanyAsync(Common.gstrSessionString, type, entity);
}
catch (Exception ex)
{
this.ProcessingDlgClose();
ExMessageBox.Show(CLASS_NM + ".UpdateCompany" + Environment.NewLine + ex.ToString(), "エラー確認");
}
}
private void SetBinding()
{
if (_entity == null)
{
_entity = new EntityCompany();
}
// マスタコントロールPropertyChanged
_entity.PropertyChanged += this.utlZip.MstID_Changed;
NumberConverter nmConvDecm0 = new NumberConverter();
nmConvDecm0.IsMaxMinCheck = true;
nmConvDecm0.MinNumber = 4;
nmConvDecm0.MaxNumber = 15;
#region Bind
// バインド
Binding BindingName = new Binding("_name");
BindingName.Mode = BindingMode.TwoWay;
BindingName.Source = _entity;
this.txtName.SetBinding(TextBox.TextProperty, BindingName);
Binding BindingKana = new Binding("_kana");
BindingKana.Mode = BindingMode.TwoWay;
BindingKana.Source = _entity;
this.txtKana.SetBinding(TextBox.TextProperty, BindingKana);
Binding BindingZipCodeFrom = new Binding("_zip_code_from");
BindingZipCodeFrom.Mode = BindingMode.TwoWay;
BindingZipCodeFrom.Source = _entity;
this.utlZip.txtZipNo1.SetBinding(TextBox.TextProperty, BindingZipCodeFrom);
Binding BindingZipCodeTo = new Binding("_zip_code_to");
BindingZipCodeTo.Mode = BindingMode.TwoWay;
BindingZipCodeTo.Source = _entity;
this.utlZip.txtZipNo2.SetBinding(TextBox.TextProperty, BindingZipCodeTo);
this.utlZip.is_zip_from_first_flg = true;
this.utlZip.is_zip_to_first_flg = true;
Binding BindingAdress1 = new Binding("_adress1");
BindingAdress1.Mode = BindingMode.TwoWay;
BindingAdress1.Source = _entity;
this.utlZip.SetBinding(Utl_Zip.UserControlAdress1Property, BindingAdress1);
Binding BindingAdress2 = new Binding("_adress2");
BindingAdress2.Mode = BindingMode.TwoWay;
BindingAdress2.Source = _entity;
this.utlZip.SetBinding(Utl_Zip.UserControlAdress2Property, BindingAdress2);
Binding BindingTel = new Binding("_tel");
BindingTel.Mode = BindingMode.TwoWay;
BindingTel.Source = _entity;
this.txtTel.SetBinding(TextBox.TextProperty, BindingTel);
Binding BindingFax = new Binding("_fax");
BindingFax.Mode = BindingMode.TwoWay;
BindingFax.Source = _entity;
this.txtFax.SetBinding(TextBox.TextProperty, BindingFax);
Binding BindingMailAdress = new Binding("_mail_adress");
BindingMailAdress.Mode = BindingMode.TwoWay;
BindingMailAdress.Source = _entity;
this.txtMail.SetBinding(TextBox.TextProperty, BindingMailAdress);
Binding BindingGroupDisplayNm = new Binding("_group_display_name");
BindingGroupDisplayNm.Mode = BindingMode.TwoWay;
BindingGroupDisplayNm.Source = _entity;
this.txtGroupDisplayNm.SetBinding(TextBox.TextProperty, BindingGroupDisplayNm);
Binding BindingIdFigureSlipNo = new Binding("_id_figure_slip_no");
BindingIdFigureSlipNo.Converter = nmConvDecm0;
BindingIdFigureSlipNo.Mode = BindingMode.TwoWay;
BindingIdFigureSlipNo.Source = _entity;
this.txtDenNoFg.SetBinding(TextBox.TextProperty, BindingIdFigureSlipNo);
Binding BindingIdFigureCustomer = new Binding("_id_figure_customer");
BindingIdFigureCustomer.Converter = nmConvDecm0;
BindingIdFigureCustomer.Mode = BindingMode.TwoWay;
BindingIdFigureCustomer.Source = _entity;
this.txtCustomerIdFg.SetBinding(TextBox.TextProperty, BindingIdFigureCustomer);
Binding BindingIdFigurePurchase = new Binding("_id_figure_purchase");
BindingIdFigurePurchase.Converter = nmConvDecm0;
BindingIdFigurePurchase.Mode = BindingMode.TwoWay;
BindingIdFigurePurchase.Source = _entity;
this.txtPurchaseIdFg.SetBinding(TextBox.TextProperty, BindingIdFigurePurchase);
Binding BindingIdFigureCommodity = new Binding("_id_figure_commodity");
BindingIdFigureCommodity.Converter = nmConvDecm0;
BindingIdFigureCommodity.Mode = BindingMode.TwoWay;
BindingIdFigureCommodity.Source = _entity;
this.txtCommdityIdFg.SetBinding(TextBox.TextProperty, BindingIdFigureCommodity);
Binding BindingEstimateYmd = new Binding("_estimate_ymd");
BindingEstimateYmd.Mode = BindingMode.TwoWay;
BindingEstimateYmd.Source = _entity;
this.txtEstimateYmd.SetBinding(TextBox.TextProperty, BindingEstimateYmd);
Binding BindingOrderYmd = new Binding("_order_ymd");
BindingOrderYmd.Mode = BindingMode.TwoWay;
BindingOrderYmd.Source = _entity;
this.txtOrderYmd.SetBinding(TextBox.TextProperty, BindingOrderYmd);
Binding BindingSalesYmd = new Binding("_sales_ymd");
BindingSalesYmd.Mode = BindingMode.TwoWay;
BindingSalesYmd.Source = _entity;
this.txtSalesYmd.SetBinding(TextBox.TextProperty, BindingSalesYmd);
Binding BindingReceiptYmd = new Binding("_receipt_ymd");
BindingReceiptYmd.Mode = BindingMode.TwoWay;
BindingReceiptYmd.Source = _entity;
this.txtReceiptYmd.SetBinding(TextBox.TextProperty, BindingReceiptYmd);
Binding BindingPurchaseOrderYmd = new Binding("_purchase_order_ymd");
BindingPurchaseOrderYmd.Mode = BindingMode.TwoWay;
BindingPurchaseOrderYmd.Source = _entity;
this.txtPurchaseOrderYmd.SetBinding(TextBox.TextProperty, BindingPurchaseOrderYmd);
Binding BindingPurchaseYmd = new Binding("_purchase_ymd");
BindingPurchaseYmd.Mode = BindingMode.TwoWay;
BindingPurchaseYmd.Source = _entity;
this.txtPurchaseYmd.SetBinding(TextBox.TextProperty, BindingPurchaseYmd);
Binding BindingCashPaymentYmd = new Binding("_cash_payment_ymd");
BindingCashPaymentYmd.Mode = BindingMode.TwoWay;
BindingCashPaymentYmd.Source = _entity;
this.txtCashPaymentYmd.SetBinding(TextBox.TextProperty, BindingCashPaymentYmd);
Binding BindingProduceYmd = new Binding("_produce_ymd");
BindingProduceYmd.Mode = BindingMode.TwoWay;
BindingProduceYmd.Source = _entity;
this.txtProduceYmd.SetBinding(TextBox.TextProperty, BindingProduceYmd);
Binding BindingShipYmd = new Binding("_ship_ymd");
BindingShipYmd.Mode = BindingMode.TwoWay;
BindingShipYmd.Source = _entity;
this.txtShipYmd.SetBinding(TextBox.TextProperty, BindingShipYmd);
Binding BindingEstimateCnt = new Binding("_estimate_cnt");
BindingEstimateCnt.Mode = BindingMode.TwoWay;
BindingEstimateCnt.Source = _entity;
this.txtEstimateCnt.SetBinding(TextBox.TextProperty, BindingEstimateCnt);
Binding BindingOrderCnt = new Binding("_order_cnt");
BindingOrderCnt.Mode = BindingMode.TwoWay;
BindingOrderCnt.Source = _entity;
this.txtOrderCnt.SetBinding(TextBox.TextProperty, BindingOrderCnt);
Binding BindingSalesCnt = new Binding("_sales_cnt");
BindingSalesCnt.Mode = BindingMode.TwoWay;
BindingSalesCnt.Source = _entity;
this.txtSalesCnt.SetBinding(TextBox.TextProperty, BindingSalesCnt);
Binding BindingReceiptCnt = new Binding("_receipt_cnt");
BindingReceiptCnt.Mode = BindingMode.TwoWay;
BindingReceiptCnt.Source = _entity;
this.txtReceiptCnt.SetBinding(TextBox.TextProperty, BindingReceiptCnt);
Binding BindingPurchaseOrderCnt = new Binding("_purchase_order_cnt");
BindingPurchaseOrderCnt.Mode = BindingMode.TwoWay;
BindingPurchaseOrderCnt.Source = _entity;
this.txtPurchaseOrderCnt.SetBinding(TextBox.TextProperty, BindingPurchaseOrderCnt);
Binding BindingPurchaseCnt = new Binding("_purchase_cnt");
BindingPurchaseCnt.Mode = BindingMode.TwoWay;
BindingPurchaseCnt.Source = _entity;
this.txtPurchaseCnt.SetBinding(TextBox.TextProperty, BindingPurchaseCnt);
Binding BindingCashPaymentCnt = new Binding("_cash_payment_cnt");
BindingCashPaymentCnt.Mode = BindingMode.TwoWay;
BindingCashPaymentCnt.Source = _entity;
this.txtCashPaymentCnt.SetBinding(TextBox.TextProperty, BindingCashPaymentCnt);
Binding BindingProduceCnt = new Binding("_produce_cnt");
BindingProduceCnt.Mode = BindingMode.TwoWay;
BindingProduceCnt.Source = _entity;
this.txtProduceCnt.SetBinding(TextBox.TextProperty, BindingProduceCnt);
Binding BindingShipCnt = new Binding("_ship_cnt");
BindingShipCnt.Mode = BindingMode.TwoWay;
BindingShipCnt.Source = _entity;
this.txtShipCnt.SetBinding(TextBox.TextProperty, BindingShipCnt);
#endregion
this.txtEstimateCnt.OnFormatString();
this.txtOrderCnt.OnFormatString();
this.txtSalesCnt.OnFormatString();
this.txtReceiptCnt.OnFormatString();
this.txtPurchaseOrderCnt.OnFormatString();
this.txtPurchaseCnt.OnFormatString();
this.txtCashPaymentCnt.OnFormatString();
this.txtProduceCnt.OnFormatString();
this.txtShipCnt.OnFormatString();
}
public override void DataSelect(int intKbn, object objList)
{
switch ((ExWebService.geWebServiceCallKbn)intKbn)
{
case _GetWebServiceCallKbn:
// 更新
if (objList != null)
{
_entity = (EntityCompany)objList;
if (_entity.message != "" && _entity.message != null)
{
//btnF12_Click(null, null);
}
else
{
// バインド反映
SetBinding();
if (_entity._lock_flg == 0)
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Upd;
}
else
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Sel;
}
before_intidFigureSlipNo = _entity._id_figure_slip_no;
before_intidFigureCustomer = _entity._id_figure_customer;
before_intidFigurePurchase = _entity._id_figure_purchase;
before_intidFigureCommodity = _entity._id_figure_commodity;
}
}
else
{
//btnF12_Click(null, null);
}
ExBackgroundWorker.DoWork_Focus(this.txtName, 10);
break;
default:
break;
}
}
private void SetBinding()
{
if (_entity == null)
{
_entity = new EntityCompany();
}
// マスタコントロールPropertyChanged
_entity.PropertyChanged += this.utlZip.MstID_Changed;
NumberConverter nmConvDecm0 = new NumberConverter();
nmConvDecm0.IsMaxMinCheck = true;
nmConvDecm0.MinNumber = 4;
nmConvDecm0.MaxNumber = 15;
#region Bind
// バインド
Binding BindingName = new Binding("_name");
BindingName.Mode = BindingMode.TwoWay;
BindingName.Source = _entity;
this.txtName.SetBinding(TextBox.TextProperty, BindingName);
Binding BindingKana = new Binding("_kana");
BindingKana.Mode = BindingMode.TwoWay;
BindingKana.Source = _entity;
this.txtKana.SetBinding(TextBox.TextProperty, BindingKana);
Binding BindingZipCodeFrom = new Binding("_zip_code_from");
BindingZipCodeFrom.Mode = BindingMode.TwoWay;
BindingZipCodeFrom.Source = _entity;
this.utlZip.txtZipNo1.SetBinding(TextBox.TextProperty, BindingZipCodeFrom);
Binding BindingZipCodeTo = new Binding("_zip_code_to");
BindingZipCodeTo.Mode = BindingMode.TwoWay;
BindingZipCodeTo.Source = _entity;
this.utlZip.txtZipNo2.SetBinding(TextBox.TextProperty, BindingZipCodeTo);
this.utlZip.is_zip_from_first_flg = true;
this.utlZip.is_zip_to_first_flg = true;
Binding BindingAdress1 = new Binding("_adress1");
BindingAdress1.Mode = BindingMode.TwoWay;
BindingAdress1.Source = _entity;
this.utlZip.SetBinding(Utl_Zip.UserControlAdress1Property, BindingAdress1);
Binding BindingAdress2 = new Binding("_adress2");
BindingAdress2.Mode = BindingMode.TwoWay;
BindingAdress2.Source = _entity;
this.utlZip.SetBinding(Utl_Zip.UserControlAdress2Property, BindingAdress2);
Binding BindingTel = new Binding("_tel");
BindingTel.Mode = BindingMode.TwoWay;
BindingTel.Source = _entity;
this.txtTel.SetBinding(TextBox.TextProperty, BindingTel);
Binding BindingFax = new Binding("_fax");
BindingFax.Mode = BindingMode.TwoWay;
BindingFax.Source = _entity;
this.txtFax.SetBinding(TextBox.TextProperty, BindingFax);
Binding BindingMailAdress = new Binding("_mail_adress");
BindingMailAdress.Mode = BindingMode.TwoWay;
BindingMailAdress.Source = _entity;
this.txtMail.SetBinding(TextBox.TextProperty, BindingMailAdress);
Binding BindingGroupDisplayNm = new Binding("_group_display_name");
BindingGroupDisplayNm.Mode = BindingMode.TwoWay;
BindingGroupDisplayNm.Source = _entity;
this.txtGroupDisplayNm.SetBinding(TextBox.TextProperty, BindingGroupDisplayNm);
Binding BindingIdFigureSlipNo = new Binding("_id_figure_slip_no");
BindingIdFigureSlipNo.Converter = nmConvDecm0;
BindingIdFigureSlipNo.Mode = BindingMode.TwoWay;
BindingIdFigureSlipNo.Source = _entity;
this.txtDenNoFg.SetBinding(TextBox.TextProperty, BindingIdFigureSlipNo);
Binding BindingIdFigureCustomer = new Binding("_id_figure_customer");
BindingIdFigureCustomer.Converter = nmConvDecm0;
BindingIdFigureCustomer.Mode = BindingMode.TwoWay;
BindingIdFigureCustomer.Source = _entity;
this.txtCustomerIdFg.SetBinding(TextBox.TextProperty, BindingIdFigureCustomer);
Binding BindingIdFigurePurchase = new Binding("_id_figure_purchase");
BindingIdFigurePurchase.Converter = nmConvDecm0;
BindingIdFigurePurchase.Mode = BindingMode.TwoWay;
BindingIdFigurePurchase.Source = _entity;
this.txtPurchaseIdFg.SetBinding(TextBox.TextProperty, BindingIdFigurePurchase);
Binding BindingIdFigureCommodity = new Binding("_id_figure_commodity");
BindingIdFigureCommodity.Converter = nmConvDecm0;
BindingIdFigureCommodity.Mode = BindingMode.TwoWay;
BindingIdFigureCommodity.Source = _entity;
this.txtCommdityIdFg.SetBinding(TextBox.TextProperty, BindingIdFigureCommodity);
Binding BindingEstimateYmd = new Binding("_estimate_ymd");
BindingEstimateYmd.Mode = BindingMode.TwoWay;
BindingEstimateYmd.Source = _entity;
this.txtEstimateYmd.SetBinding(TextBox.TextProperty, BindingEstimateYmd);
Binding BindingOrderYmd = new Binding("_order_ymd");
BindingOrderYmd.Mode = BindingMode.TwoWay;
BindingOrderYmd.Source = _entity;
this.txtOrderYmd.SetBinding(TextBox.TextProperty, BindingOrderYmd);
Binding BindingSalesYmd = new Binding("_sales_ymd");
BindingSalesYmd.Mode = BindingMode.TwoWay;
BindingSalesYmd.Source = _entity;
this.txtSalesYmd.SetBinding(TextBox.TextProperty, BindingSalesYmd);
Binding BindingReceiptYmd = new Binding("_receipt_ymd");
BindingReceiptYmd.Mode = BindingMode.TwoWay;
BindingReceiptYmd.Source = _entity;
this.txtReceiptYmd.SetBinding(TextBox.TextProperty, BindingReceiptYmd);
Binding BindingPurchaseOrderYmd = new Binding("_purchase_order_ymd");
BindingPurchaseOrderYmd.Mode = BindingMode.TwoWay;
BindingPurchaseOrderYmd.Source = _entity;
this.txtPurchaseOrderYmd.SetBinding(TextBox.TextProperty, BindingPurchaseOrderYmd);
Binding BindingPurchaseYmd = new Binding("_purchase_ymd");
BindingPurchaseYmd.Mode = BindingMode.TwoWay;
BindingPurchaseYmd.Source = _entity;
this.txtPurchaseYmd.SetBinding(TextBox.TextProperty, BindingPurchaseYmd);
Binding BindingCashPaymentYmd = new Binding("_cash_payment_ymd");
BindingCashPaymentYmd.Mode = BindingMode.TwoWay;
BindingCashPaymentYmd.Source = _entity;
this.txtCashPaymentYmd.SetBinding(TextBox.TextProperty, BindingCashPaymentYmd);
Binding BindingProduceYmd = new Binding("_produce_ymd");
BindingProduceYmd.Mode = BindingMode.TwoWay;
BindingProduceYmd.Source = _entity;
this.txtProduceYmd.SetBinding(TextBox.TextProperty, BindingProduceYmd);
Binding BindingShipYmd = new Binding("_ship_ymd");
BindingShipYmd.Mode = BindingMode.TwoWay;
BindingShipYmd.Source = _entity;
this.txtShipYmd.SetBinding(TextBox.TextProperty, BindingShipYmd);
Binding BindingEstimateCnt = new Binding("_estimate_cnt");
BindingEstimateCnt.Mode = BindingMode.TwoWay;
BindingEstimateCnt.Source = _entity;
this.txtEstimateCnt.SetBinding(TextBox.TextProperty, BindingEstimateCnt);
Binding BindingOrderCnt = new Binding("_order_cnt");
BindingOrderCnt.Mode = BindingMode.TwoWay;
BindingOrderCnt.Source = _entity;
this.txtOrderCnt.SetBinding(TextBox.TextProperty, BindingOrderCnt);
Binding BindingSalesCnt = new Binding("_sales_cnt");
BindingSalesCnt.Mode = BindingMode.TwoWay;
BindingSalesCnt.Source = _entity;
this.txtSalesCnt.SetBinding(TextBox.TextProperty, BindingSalesCnt);
Binding BindingReceiptCnt = new Binding("_receipt_cnt");
BindingReceiptCnt.Mode = BindingMode.TwoWay;
BindingReceiptCnt.Source = _entity;
this.txtReceiptCnt.SetBinding(TextBox.TextProperty, BindingReceiptCnt);
Binding BindingPurchaseOrderCnt = new Binding("_purchase_order_cnt");
BindingPurchaseOrderCnt.Mode = BindingMode.TwoWay;
BindingPurchaseOrderCnt.Source = _entity;
this.txtPurchaseOrderCnt.SetBinding(TextBox.TextProperty, BindingPurchaseOrderCnt);
Binding BindingPurchaseCnt = new Binding("_purchase_cnt");
BindingPurchaseCnt.Mode = BindingMode.TwoWay;
BindingPurchaseCnt.Source = _entity;
this.txtPurchaseCnt.SetBinding(TextBox.TextProperty, BindingPurchaseCnt);
Binding BindingCashPaymentCnt = new Binding("_cash_payment_cnt");
BindingCashPaymentCnt.Mode = BindingMode.TwoWay;
BindingCashPaymentCnt.Source = _entity;
this.txtCashPaymentCnt.SetBinding(TextBox.TextProperty, BindingCashPaymentCnt);
Binding BindingProduceCnt = new Binding("_produce_cnt");
BindingProduceCnt.Mode = BindingMode.TwoWay;
BindingProduceCnt.Source = _entity;
this.txtProduceCnt.SetBinding(TextBox.TextProperty, BindingProduceCnt);
Binding BindingShipCnt = new Binding("_ship_cnt");
BindingShipCnt.Mode = BindingMode.TwoWay;
BindingShipCnt.Source = _entity;
this.txtShipCnt.SetBinding(TextBox.TextProperty, BindingShipCnt);
#endregion
this.txtEstimateCnt.OnFormatString();
this.txtOrderCnt.OnFormatString();
this.txtSalesCnt.OnFormatString();
this.txtReceiptCnt.OnFormatString();
this.txtPurchaseOrderCnt.OnFormatString();
this.txtPurchaseCnt.OnFormatString();
this.txtCashPaymentCnt.OnFormatString();
this.txtProduceCnt.OnFormatString();
this.txtShipCnt.OnFormatString();
}
