public async Task <IActionResult> PutEntityCustomer(int id, EntityCustomer entityCustomer)
{
if (id != entityCustomer.Id)
{
return(BadRequest());
}
_context.Entry(entityCustomer).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EntityCustomerExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <EntityCustomer> > PostEntityCustomer(EntityCustomer entityCustomer)
{
_context.EntityCustomers.Add(entityCustomer);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetEntityCustomer", new { id = entityCustomer.Id }, entityCustomer));
}
/// <summary>
/// 更新客户档案
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public string UpdateCustomer(EntityCustomer entity)
{
if (entity == null)
{
throw new JRException("客户档案更新失败!没有数据!");
}
string sql = string.Format(@"Update Customer Set cCusName=@cCusName,cCusAbbName=@cCusAbbName,cCCCode=@cCCCode,cCusAddress=@cCusAddress
,cCusHand=@cCusHand,cCusPerson=@cCusPerson,cCusDepart=@cCusDepart,cCusDefine1=@cCusDefine1
Where cCusCode=@cCusCode");
SqlParameter[] para =
{
new SqlParameter("@cCusCode", GetDBValue(entity.cCusCode)),
new SqlParameter("@cCusName", GetDBValue(entity.cCusName)),
new SqlParameter("@cCusAbbName", GetDBValue(entity.cCusAbbName)),
new SqlParameter("@cCCCode", GetDBValue(entity.cCCCode)),
new SqlParameter("@cMaker", GetDBValue(entity.cMaker)),
new SqlParameter("@cCusAddress", GetDBValue(entity.cCusAddress)),
new SqlParameter("@cCusHand", GetDBValue(entity.cCusHand)),
new SqlParameter("@cCusPerson", GetDBValue(entity.cCusPerson)),
new SqlParameter("@cCusDefine1", GetDBValue(entity.cCusDefine1)),
new SqlParameter("@cCusDepart", GetDBValue(entity.cCusDepart)),
};
int headCount = this.DB_SqlHelper.ExecuteNonQuery(sql, para);
return(entity.cCusCode);
}
public int UpdateCustomer(EntityCustomer entity)
{
string SqlStr = "";
SqlStr = "update tc_customer set ";
SqlStr += "customer_name = '" + entity.Customer_name.Trim() + "' ";
SqlStr += ",customer_yxm = '" + entity.Customer_yxm.Trim() + "' ";
SqlStr += ",customer_artificial_person = '" + entity.Customer_artificial_person.Trim() + "' ";
SqlStr += ",customer_bank = '" + entity.Customer_bank.Trim() + "' ";
SqlStr += ",customer_bank_num = '" + entity.Customer_bank_num.Trim() + "' ";
SqlStr += ",customer_address = '" + entity.Customer_address.Trim() + "' ";
SqlStr += ",customer_principal = '" + entity.Customer_principal.Trim() + "' ";
SqlStr += ",customer_tariff_num = '" + entity.Customer_tariff_num.Trim() + "' ";
SqlStr += ",customer_licence = '" + entity.Customer_licence.Trim() + "' ";
SqlStr += ",customer_business_licence = '" + entity.Customer_business_licence.Trim() + "' ";
SqlStr += ",customer_type = '" + entity.Customer_type.Trim() + "' ";
SqlStr += ",customer_tel = '" + entity.Customer_tel.Trim() + "' ";
SqlStr += ",customer_fax = '" + entity.Customer_fax.Trim() + "' ";
SqlStr += ",customer_postal_code = '" + entity.Customer_postal_code.Trim() + "' ";
SqlStr += ",customer_medical_institutions = '" + entity.Customer_medical_institutions.Trim() + "' ";
SqlStr += ",customer_quality = '" + entity.Customer_quality.Trim() + "' ";
SqlStr += ",customer_flag = '" + entity.Customer_flag.Trim() + "' ";
SqlStr += " where customer_code= '" + entity.Customer_code.Trim() + "' ";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
ExcuteSql(sqlCommand);
return(Constants.SystemConfig.SERVER_SUCCESS);
}
public ActionResult DeleteConfirmed(int id)
{
EntityCustomer entityCustomer = db.EntityCustomers.Find(id);
db.EntityCustomers.Remove(entityCustomer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult CreateNewCustomer([FromBody] EntityCustomer customerEntity)
{
if (_customers.Any(x => x.Id == customerEntity.Id))
{
return(BadRequest());
}
_customers.Add(customerEntity);
return(Ok(customerEntity));
}
public ActionResult Create(EntityCustomer entityCustomer)
{
if (ModelState.IsValid)
{
db.EntityCustomers.Add(entityCustomer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(entityCustomer));
}
public ActionResult Edit(EntityCustomer entityCustomer)
{
if (ModelState.IsValid)
{
db.Database.Log = Console.WriteLine;
var entry = db.Entry(entityCustomer);
entry.State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(entityCustomer));
}
// GET: EntityCustomer/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EntityCustomer entityCustomer = db.EntityCustomers.Find(id);
if (entityCustomer == null)
{
return(HttpNotFound());
}
return(View(entityCustomer));
}
public string InsertCustomer(EntityCustomer entity)
{
if (entity == null)
{
throw new JRException("客户档案新增失败!没有数据!");
}
string sql = string.Format(@"insert into Customer(cCusCode,cCusName,cCusAbbName,cCCCode,cDCCode,cTrade,
cCusAddress,cCusPostCode,cCusRegCode,dCusDevDate,cCusLPerson,cCusEmail,cCusPerson,cCusPhone,cCusFax,cCusBP,cCusHand,
cCusPPerson,iCusDisRate,cCusCreGrade,iCusCreLine,iCusCreDate,cCusPayCond,cCusOType,cCusHeadCode,cCusWhCode,cCusDepart,
iARMoney,dLastDate,iLastMoney,dLRDate,iLRMoney,dEndDate,iFrequency,cCusDefine1,cCusDefine2,cCusDefine3,iCostGrade,
cCreatePerson,cModifyPerson,dModifyDate,cRelVendor,iId,cPriceGroup,cOfferGrade,iOfferRate,cCusDefine4,cCusDefine5,
cCusDefine6,cCusDefine7,cCusDefine8,cCusDefine9,cCusDefine10,cCusDefine11,cCusDefine12,cCusDefine13,cCusDefine14,
cCusDefine15,cCusDefine16,cInvoiceCompany,bCredit,bCreditDate,dLicenceSDate,dLicenceEDate,iLicenceADays,dBusinessSDate,
dBusinessEDate,iBusinessADays,dProxySDate,dProxyEDate,iProxyADays,cMemo,bLimitSale,cCusCountryCode,cCusEnName,
cCusEnAddr1,cCusEnAddr2,cCusEnAddr3,cCusEnAddr4,cCusPortCode,cPrimaryVen,fCommisionRate,fInsueRate,bHomeBranch,
cBranchAddr,cBranchPhone,cBranchPerson,cCusTradeCCode,CustomerKCode,bCusState,bShop,cCusExch_name,bCusDomestic,
bCusOverseas,cCusCreditCompany,cCusSAProtocol,cCusExProtocol,cCusOtherProtocol,fCusDiscountRate,cCusSSCode,
cCusCMProtocol,dCusCreateDatetime,cCusMnemCode,fAdvancePaymentRatio,bServiceAttribute,bRequestSign,bOnGPinStore,
cCusMngTypeCode,account_type,cCusImAgentProtocol) values
(@cCusCode,@cCusName,@cCusAbbName,@cCCCode,NULL,NULL,@cCusAddress,NULL,NULL,GetDate(),
NULL,NULL,@cCusPerson,NULL,NULL,NULL,@cCusHand,NULL,0,NULL,0,0,NULL,NULL,@cCusCode,NULL,@cCusDepart,0,NULL,0,NULL,0,
NULL,0,@cCusDefine1,NULL,NULL,-1,@cMaker,@cMaker,GetDate(),NULL,@cCusCode,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,@cCusCode,0,0,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,
0,0,N'人民币',1,0,@cCusCode,NULL,NULL,NULL,NULL,NULL,NULL,GetDate(),NULL,NULL,0,0,0,N'999',26,NULL);
insert into sa_invoicecustomers(ccuscode,cinvoicecompany,bdefault) values (@cCusCode,@cCusCode,1 );
insert into Customer_extradefine(cCusCode) values (@cCusCode);");
SqlParameter[] para =
{
new SqlParameter("@cCusCode", GetDBValue(entity.cCusCode)),
new SqlParameter("@cCusName", GetDBValue(entity.cCusName)),
new SqlParameter("@cCusAbbName", GetDBValue(entity.cCusAbbName)),
new SqlParameter("@cCCCode", GetDBValue(entity.cCCCode)),
new SqlParameter("@cMaker", GetDBValue(entity.cMaker)),
new SqlParameter("@cCusAddress", GetDBValue(entity.cCusAddress)),
new SqlParameter("@cCusHand", GetDBValue(entity.cCusHand)),
new SqlParameter("@cCusPerson", GetDBValue(entity.cCusPerson)),
new SqlParameter("@cCusDefine1", GetDBValue(entity.cCusDefine1)),
new SqlParameter("@cCusDepart", GetDBValue(entity.cCusDepart)),
};
int headCount = this.DB_SqlHelper.ExecuteNonQuery(sql, para);
return(entity.cCusCode);
}
private void bt_customer_Click(object sender, EventArgs e)
{
EntityCustomer doc = new EntityCustomer();
doc.cCusCode = "test110";
doc.cCusName = "测试客户110";
doc.cCusAbbName = "测试客户110";
doc.cCCCode = "SZ01";
doc.cCusDepart = "SZ300104";
doc.cCusHand = "18836241241";
doc.cCusAddress = "紫光信息港";
doc.cCusDefine1 = "1+5渠道";
doc.cCusPerson = "张三";
string entity = System.Web.HttpUtility.UrlEncode(JsonConvert.SerializeObject(doc));
string postUrl = string.Format(@"{0}={1}&ModelType=8008", addpara, entity);
string result = SendHttpRequest(addurl, postUrl, "POST");
textBox1.Text = result;
}
public ActionResult UpdateCustomer(int id, [FromBody] EntityCustomer customerEntity)
{
if (customerEntity == null)
{
return(BadRequest());
}
var customer = _customers.FirstOrDefault(x => x.Id == customerEntity.Id);
if (customer == null)
{
return(NotFound());
}
customer.FirstName = customerEntity.FirstName;
customer.LastName = customerEntity.LastName;
customer.BoughtVehicles = customerEntity.BoughtVehicles;
return(Ok(customer));
}
public string AddCustomer(string UserCode, string PlainPassword,
string StrAccID, int AccYear, string Act, EntityCustomer entity, out int success)
{
success = 0;
#region 验证
// 字段必填项验证
string msg = "";
if (!entity.CheckEntity(out msg))
{
return(msg);
}
if (string.IsNullOrWhiteSpace(GetCustomerClass(entity.cCCCode)))
{
return(string.Format("U8中不存在客户分类编码或分类编码非末级:{0}!", entity.cCCCode));
}
if (string.IsNullOrWhiteSpace(GetDepartmentName(entity.cCusDepart)))
{
return(string.Format("U8中不存在部门编码:{0},或者部门编码非末级!", entity.cCusDepart));
}
if (!string.IsNullOrWhiteSpace(GetCustomercCusAbbName(entity.cCusAbbName, entity.cCusCode)))
{
return(string.Format("U8中已存在客户简称:{0}!", entity.cCusAbbName));
}
#endregion
entity.cMaker = GetUserName(UserCode);
string id = "";
if (!string.IsNullOrWhiteSpace(IsGetCustomer(entity.cCusCode)))
{
id = UpdateCustomer(entity);
}
else
{
id = InsertCustomer(entity);
}
success = string.IsNullOrWhiteSpace(id) ? 0 : 1;;
return(id);
}
public int InsertCustomer(EntityCustomer entityCustomer)
{
string SqlStr = "";
SqlStr = "insert into tc_customer";
SqlStr += " values('"
+ entityCustomer.Customer_code.Trim() + "','"
+ entityCustomer.Customer_name.Trim() + "','"
+ entityCustomer.Customer_yxm.Trim() + "','"
+ entityCustomer.Customer_artificial_person.Trim() + "','"
+ entityCustomer.Customer_bank.Trim() + "','"
+ entityCustomer.Customer_bank_num.Trim() + "','"
+ entityCustomer.Customer_address.Trim() + "','"
+ entityCustomer.Customer_principal.Trim() + "','"
+ entityCustomer.Customer_tariff_num.Trim() + "','"
+ entityCustomer.Customer_licence.Trim() + "','"
+ entityCustomer.Customer_business_licence.Trim() + "','"
+ entityCustomer.Customer_type.Trim() + "','"
+ entityCustomer.Customer_tel.Trim() + "','"
+ entityCustomer.Customer_fax.Trim() + "','"
+ entityCustomer.Customer_postal_code.Trim() + "','"
+ entityCustomer.Customer_medical_institutions.Trim() + "','"
+ entityCustomer.Customer_quality.Trim() + "','"
+ entityCustomer.Customer_flag.Trim() + "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
try
{
ExcuteSql(sqlCommand);
}
catch
{
return(Constants.SystemConfig.SERVER_ERROR);
}
return(Constants.SystemConfig.SERVER_SUCCESS);
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/11/8 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
//判断客户编号不能为空
if (txtCustomer_usecode.Text.Trim() == string.Empty)
{
MessageBox.Show("客户编号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_usecode.Focus();
return;
}
//判断客户名称不能为空
if (txtCustomer_name.Text.Trim() == string.Empty)
{
MessageBox.Show("客户姓名不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_name.Focus();
return;
}
//判断非法字符
foreach (Control control in groupBox1.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
EntityCustomer entityCustomer = new EntityCustomer();
EntityArchives entityArchives = new EntityArchives();
int result1 = -1;
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
//向客户实体类添加数据
entityCustomer.Customer_name = txtCustomer_name.Text;
entityCustomer.Customer_yxm = txtCustomer_yxm.Text;
entityCustomer.Customer_tel = txtCustomer_tel.Text;
entityCustomer.Customer_address = txtCustomer_address.Text;
//向档案实体类添加数据
entityArchives.Customer_age = txtCustomer_age.Text;
entityArchives.Customer_usecode = txtCustomer_usecode.Text;
entityArchives.Customer_sex = cbCustomer_sex.Text;
//添加标识, "1",固定为个人客户
entityCustomer.Customer_flag = "1";
dataAccess = new DataAccess();
dataAccess.Open();
GetData getData = new GetData(dataAccess.Connection);
if (getData.InsertIsOnly("tc_archives", "customer_usecode", txtCustomer_usecode.Text.Trim()))
{
MessageBox.Show("您输入的客户编号已经存在！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_usecode.Focus();
return;
}
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
string code = primaryKey.MakeCode("客户");
entityCustomer.Customer_code = code;
entityArchives.Customer_code = code;
result = getData.InsertCustomer(entityCustomer);
result1 = getData.InsertArchives(entityArchives);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entityCustomer.Customer_code = dgv.SelectedRows[0].Cells["CUSTOMER_code"].Value.ToString();
entityCustomer.Customer_name = txtCustomer_name.Text;
entityCustomer.Customer_yxm = txtCustomer_yxm.Text;
entityCustomer.Customer_tel = txtCustomer_tel.Text;
entityCustomer.Customer_address = txtCustomer_address.Text;
//添加标识, "1",固定为个人客户
entityCustomer.Customer_flag = "1";
//向档案实体类添加数据
entityArchives.Customer_age = txtCustomer_age.Text;
entityArchives.Customer_usecode = txtCustomer_usecode.Text;
entityArchives.Customer_sex = cbCustomer_sex.Text;
entityArchives.Customer_code = entityCustomer.Customer_code;
entityArchives.Archives_id = Convert.ToInt32(dgv.SelectedRows[0].Cells["Archives_id"].Value.ToString());
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//判断客户编号重复
if (getData.UpdateIsOnly("tc_archives", "Archives_id", entityArchives.Archives_id.ToString(), "customer_usecode", txtCustomer_usecode.Text.Trim()))
{
MessageBox.Show("您输入的客户编号已经存在！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_usecode.Focus();
return;
}
//取得结果符
result = getData.UpdateCustomer(entityCustomer);
result1 = getData.UpdateArchives(entityArchives);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
if (result == 0 && result1 == 0)
{
MessageBox.Show("数据已经保存成功！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BandingDgv();
}
else
{
MessageBox.Show("数据保存时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
}
private void GetCustomerCompleted(Object sender, GetCustomerCompletedEventArgs e)
{
try
{
objCustomer = e.Result;
if (DialogCloseFlg == geDialogCloseFlg.Yes & win != null)
{
win.Close();
win = null;
}
if (objCustomer != null)
{
if (objCustomer.message != "" && objCustomer.message != null)
{
// 失敗
ExMessageBox.Show(objCustomer.message);
objPerent.DataSelect((int)geWebServiceCallKbn.GetCustomer, (object)objCustomer);
}
else
{
// 成功
objPerent.DataSelect((int)geWebServiceCallKbn.GetCustomer, (object)objCustomer);
}
}
else
{
objPerent.DataSelect((int)geWebServiceCallKbn.GetCustomer, null);
}
}
catch (Exception ex)
{
this.ProcessingDlgClose();
ExMessageBox.Show(CLASS_NM + ".GetCustomerCompleted" + Environment.NewLine + ex.ToString(), "エラー確認");
}
finally
{
if (DialogCloseFlg == geDialogCloseFlg.Yes & win != null)
{
win.Close();
win = null;
}
}
}
private void GetCustomer(string id)
{
try
{
objCustomer = null; // 初期化
svcCustomerClient svc = new svcCustomerClient();
svc.GetCustomerCompleted += new EventHandler<GetCustomerCompletedEventArgs>(this.GetCustomerCompleted);
svc.GetCustomerAsync(Common.gstrSessionString, id);
}
catch (Exception ex)
{
this.ProcessingDlgClose();
ExMessageBox.Show(CLASS_NM + ".GetCustomer" + Environment.NewLine + ex.ToString(), "エラー確認");
}
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/07/13 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
if (txtCustomer_name.Text.Trim() == string.Empty)
{
MessageBox.Show("客户名称不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomer_name.Focus();
return;
}
if (cb_customer_type.SelectedIndex == 0)
{
MessageBox.Show("客户性质不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
cb_customer_type.Focus();
return;
}
//判断非法字符
foreach (Control control in groupBox1.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;
}
}
}
EntityCustomer entityCustomer = new EntityCustomer();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entityCustomer.Customer_name = txtCustomer_name.Text;
entityCustomer.Customer_yxm = txtCustomer_yxm.Text;
entityCustomer.Customer_artificial_person = txtCustomer_artificial_person.Text;
entityCustomer.Customer_bank = txtCustomer_bank.Text;
entityCustomer.Customer_bank_num = txtCustomer_bank_num.Text;
entityCustomer.Customer_address = txtCustomer_address.Text;
entityCustomer.Customer_principal = txtCustomer_principal.Text;
entityCustomer.Customer_tariff_num = txtCustomer_tariff_num.Text;
entityCustomer.Customer_licence = txtCustomer_licence.Text;
entityCustomer.Customer_business_licence = txtCustomer_business_licence.Text;
entityCustomer.Customer_tel = txtCustomer_tel.Text;
entityCustomer.Customer_fax = txtCustomer_fax.Text;
entityCustomer.Customer_postal_code = txtCustomer_postal_code.Text;
entityCustomer.Customer_medical_institutions = txtCustomer_medical_institutions.Text;
entityCustomer.Customer_quality = txtCustomer_quality.Text;
entityCustomer.Customer_type = cb_customer_type.Text;
entityCustomer.Customer_flag = "0";
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
entityCustomer.Customer_code = primaryKey.MakeCode("客户");
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertCustomer(entityCustomer);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgvCustomer.SelectedRows[0].Index;
entityCustomer.Customer_code = txtCustomer_code.Text;
entityCustomer.Customer_name = txtCustomer_name.Text;
entityCustomer.Customer_yxm = txtCustomer_yxm.Text;
entityCustomer.Customer_artificial_person = txtCustomer_artificial_person.Text;
entityCustomer.Customer_bank = txtCustomer_bank.Text;
entityCustomer.Customer_bank_num = txtCustomer_bank_num.Text;
entityCustomer.Customer_address = txtCustomer_address.Text;
entityCustomer.Customer_principal = txtCustomer_principal.Text;
entityCustomer.Customer_tariff_num = txtCustomer_tariff_num.Text;
entityCustomer.Customer_licence = txtCustomer_licence.Text;
entityCustomer.Customer_business_licence = txtCustomer_business_licence.Text;
entityCustomer.Customer_tel = txtCustomer_tel.Text;
entityCustomer.Customer_fax = txtCustomer_fax.Text;
entityCustomer.Customer_postal_code = txtCustomer_postal_code.Text;
entityCustomer.Customer_medical_institutions = txtCustomer_medical_institutions.Text;
entityCustomer.Customer_quality = txtCustomer_quality.Text;
entityCustomer.Customer_type = cb_customer_type.Text;
entityCustomer.Customer_flag = "0";
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateCustomer(entityCustomer);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BandingDgv();
}
else
{
MessageBox.Show("数据保存时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
}
public string AddModels(string UserCode, string CipherPassword, int ModelType,
string StrAccID, string Act, string Entity)
{
//Entity = System.Web.HttpUtility.UrlDecode(Entity);
string plainPassword = DefineEncryptDecrypt.Decrypt(CipherPassword);
int AccYear = U8BllBase.GetBeginYear(StrAccID);
if (AccYear == 0)
{
return(ControllerHelp.GetReturnStr(0, string.Format("没有找到账套号:{0}", StrAccID)));
}
int success = 0;
ModelsType mt = (ModelsType)ModelType;
switch (mt)
{
case ModelsType.Sale: // 销售订单
lock (SaleLock)
{
if (Act == "add")
{
EntitySaleHead entity = JsonConvert.DeserializeObject <EntitySaleHead>(Entity);
SoMainBll bll = new SoMainBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddSale(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.RdRecord09: // 配送出库单(其他出库单)
lock (RdRecord09Lock)
{
if (Act == "add")
{
EntityRdRecord09Head entity = JsonConvert.DeserializeObject <EntityRdRecord09Head>(Entity);
RdRecord09Bll bll = new RdRecord09Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddRdRecord09(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.DispatchList1: //销售退货单
case ModelsType.DispatchList4: //委托代销退货单
lock (DispatchList1Lock)
{
if (Act == "add")
{
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddDispatchList(UserCode, plainPassword, StrAccID, AccYear, Act, ModelsType.DispatchList1 == mt ? 0 : 1, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.DispatchList2: //销售发货单
case ModelsType.DispatchList3: //委托代销发货单
lock (DispatchList2Lock)
{
if (Act == "add")
{
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddDispatchList(UserCode, plainPassword, ModelType, StrAccID, AccYear, Act, ModelsType.DispatchList2 == mt ? 0 : 1, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Ap_CloseBill: //收款单
lock (Ap_CloseBillLock)
{
if (Act == "add")
{
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddAp_CloseBill(UserCode, plainPassword, StrAccID, AccYear, Act, ModelType, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Ap_Vouch: //其他应付款
lock (Ap_VouchLock)
{
if (Act == "add")
{
EntityAp_VouchHead entity = JsonConvert.DeserializeObject <EntityAp_VouchHead>(Entity);
Ap_VouchBll bll = new Ap_VouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddAp_Vouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.PO_Pomain: //采购订单
lock (PO_PomainLock)
{
if (Act == "add")
{
EntityPO_Pomain entity = JsonConvert.DeserializeObject <EntityPO_Pomain>(Entity);
PO_PomainBll bll = new PO_PomainBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddPO_Pomain(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.RdRecord01: //采购入库单
lock (RdRecord01Lock)
{
if (Act == "add")
{
EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity);
RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddRdRecord01(UserCode, plainPassword, StrAccID, AccYear, Act, 0, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.PayAp_CloseBill: //付款单
lock (PayAp_CloseBillLock)
{
if (Act == "add")
{
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddAp_CloseBill(UserCode, plainPassword, StrAccID, AccYear, Act, ModelType, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.ST_AppTransVouch: //调拨申请单
lock (ST_AppTransVouchLock)
{
if (Act == "add")
{
EntityST_AppTransVouch entity = JsonConvert.DeserializeObject <EntityST_AppTransVouch>(Entity);
ST_AppTransVouchBll bll = new ST_AppTransVouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddST_AppTransVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.TransVouch: //调拨单
lock (TransVouchLock)
{
if (Act == "add")
{
EntityTransVouch entity = JsonConvert.DeserializeObject <EntityTransVouch>(Entity);
TransVouchBll bll = new TransVouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddTransVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Vendor: //供应商
lock (VendorLock)
{
if (Act == "add")
{
EntityVendor entity = JsonConvert.DeserializeObject <EntityVendor>(Entity);
VendorBll bll = new VendorBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddVendor(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.CheckVouch: //盘点单
lock (VendorLock)
{
if (Act == "add")
{
EntityCheckVouchHead entity = JsonConvert.DeserializeObject <EntityCheckVouchHead>(Entity);
CheckVouchBll bll = new CheckVouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddCheckVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.InventoryClass: //存货分类
lock (InventoryClassLock)
{
if (Act == "add")
{
EntityInventoryClass entity = JsonConvert.DeserializeObject <EntityInventoryClass>(Entity);
InventoryClassBll bll = new InventoryClassBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddInventoryClass(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Inventory: //存货档案
lock (InventoryLock)
{
if (Act == "add")
{
EntityInventory entity = JsonConvert.DeserializeObject <EntityInventory>(Entity);
InventoryBll bll = new InventoryBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddInventory(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.WareHouse: //仓库档案
lock (WareHouseLock)
{
if (Act == "add")
{
EntityWareHouse entity = JsonConvert.DeserializeObject <EntityWareHouse>(Entity);
WareHouseBll bll = new WareHouseBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddWareHouse(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Customer: //客户档案
lock (CustomerLock)
{
if (Act == "add")
{
EntityCustomer entity = JsonConvert.DeserializeObject <EntityCustomer>(Entity);
CustomerBll bll = new CustomerBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddCustomer(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.RdRecord01T: //红字采购入库单
lock (RdRecord01TLock)
{
if (Act == "add")
{
EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity);
RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddRdRecord01(UserCode, plainPassword, StrAccID, AccYear, Act, 1, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
}
return(ControllerHelp.GetReturnStr(0, "AddModels中没有找到可对应的操作项"));
}
public string GetModels(string UserCode, string CipherPassword, int ModelType,
string StrAccID, string Act, string Entity, string dModifyDate)
{
//Entity = System.Web.HttpUtility.UrlDecode(Entity);
string plainPassword = DefineEncryptDecrypt.Decrypt(CipherPassword);
int AccYear = U8BllBase.GetBeginYear(StrAccID);
if (AccYear == 0)
{
return(ControllerHelp.GetReturnStr(0, string.Format("没有找到账套号{0}", StrAccID)));
}
ModelsType mt = (ModelsType)ModelType;
string msg = "";
switch (mt)
{
case ModelsType.CurrentStock: // 库存量查询
if (Act == "get")
{
EntityCurrentStock entity = JsonConvert.DeserializeObject <EntityCurrentStock>(Entity);
CurrentStockBll bll = new CurrentStockBll(StrAccID, AccYear, UserCode, plainPassword);
List <EntityCurrentStock> list = bll.GetCurrentStock(entity, out msg);
return(ControllerHelp.GetReturnStr(string.IsNullOrWhiteSpace(msg) ? 1 : 0, "", list));
}
break;
case ModelsType.Sale: // 查询销售订单是否存在 1表示不存在，2表示存在
if (Act == "query")
{
SoMainBll bll = new SoMainBll(StrAccID, AccYear, UserCode, plainPassword);
EntitySaleHead entity = JsonConvert.DeserializeObject <EntitySaleHead>(Entity);
int num = bll.QuerySale(entity.cSOCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.DispatchList1: //退货单 1表示不存在，2表示存在
if (Act == "query")
{
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
int num = bll.QueryDispatchList(entity.cDLCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.DispatchList2: //发货单 1表示不存在，2表示存在
if (Act == "query")
{
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
int num = bll.QueryDispatchList(entity.cDLCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.RdRecord09: // 配送出库单(其他出库单) 1表示不存在，2表示存在
if (Act == "query")
{
RdRecord09Bll bll = new RdRecord09Bll(StrAccID, AccYear, UserCode, plainPassword);
EntityRdRecord09Head entity = JsonConvert.DeserializeObject <EntityRdRecord09Head>(Entity);
int num = bll.QueryRdRecord09(entity.cCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.Ap_CloseBill: //收款单（汇款通知单）1表示不存在，2表示存在
if (Act == "query")
{
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
int num = bll.QueryAp_CloseBill(entity.cVouchID);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.PayAp_CloseBill: //付款单（汇款通知单）1表示不存在，2表示存在
if (Act == "query")
{
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
int num = bll.QueryAp_CloseBill(entity.cVouchID);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.ReturnAnalysis: //退货分析表查询
if (Act == "get")
{
ReturnAnalysisBll bll = new ReturnAnalysisBll(StrAccID, AccYear, UserCode, plainPassword);
EntityReturnAnalysisRQC entity = JsonConvert.DeserializeObject <EntityReturnAnalysisRQC>(Entity);
List <EntityReturnAnalysisReport> list = bll.GetReturnAnalysis(entity);
return(ControllerHelp.GetReturnStr(1, "", list));
}
break;
case ModelsType.Customer: //客户档案
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
EntityCustomer entity = JsonConvert.DeserializeObject <EntityCustomer>(Entity);
List <EntityCustomer> customer = bll.GetCustomer(entity.cCusCode);
return(ControllerHelp.GetReturnStr(1, "", customer));
}
break;
case ModelsType.Vendor: //供应商档案
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntityVendor> vendor = bll.GetVendor();
return(ControllerHelp.GetReturnStr(1, "", vendor));
}
break;
case ModelsType.PurchaseType: //采购类型
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntityPurchaseType> purchasetype = bll.GetPurchaseType();
return(ControllerHelp.GetReturnStr(1, "", purchasetype));
}
break;
case ModelsType.Inventory: //存货档案
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntityInventory> inventory = new List <EntityInventory>();
if (string.IsNullOrWhiteSpace(dModifyDate))
{
inventory = bll.GetInventory();
}
else
{
inventory = bll.GetInventory(Convert.ToDateTime(dModifyDate));
}
return(ControllerHelp.GetReturnStr(1, "", inventory));
}
break;
case ModelsType.WareHouse: //仓库档案（入库仓库）
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntityWareHouse> warehouse = bll.GetWareHouse();
return(ControllerHelp.GetReturnStr(1, "", warehouse));
}
break;
case ModelsType.rd_Style: //入库类别档案
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <Entityrd_Style> rd_style = bll.Getrd_Style();
return(ControllerHelp.GetReturnStr(1, "", rd_style));
}
break;
case ModelsType.SettleStyle: //结算方式
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
List <EntitySettleStyle> settlestyle = bll.GetSettleStyle();
return(ControllerHelp.GetReturnStr(1, "", settlestyle));
}
break;
case ModelsType.CustomerProperty: //经营属性
if (Act == "get")
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
string cuscode = Entity;
var customer = bll.GetCustomerProperty(cuscode);
return(ControllerHelp.GetReturnStr(1, "", customer));
}
break;
case ModelsType.InventoryPrice: //存货入库含税单价
if (Act == "get")
{
if (!string.IsNullOrWhiteSpace(Entity))
{
U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword);
EntityInventoryPrice entity = JsonConvert.DeserializeObject <EntityInventoryPrice>(Entity);
var inventoryPrice = bll.GetInventoryPrice(entity.cVenCode, entity.cInvCode);
return(ControllerHelp.GetReturnStr(1, "", inventoryPrice));
}
}
break;
case ModelsType.PO_Pomain: //采购订单
if (Act == "query")
{
PO_PomainBll bll = new PO_PomainBll(StrAccID, AccYear, UserCode, plainPassword);
EntityPO_Pomain entity = JsonConvert.DeserializeObject <EntityPO_Pomain>(Entity);
int num = bll.GetPO_Pomain(entity.cPOID);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.RdRecord01: //采购入库单
if (Act == "query")
{
RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword);
EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity);
int num = bll.GetRdRecord01(entity.cCode);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
case ModelsType.Ap_Vouch: //其他应付单
if (Act == "query")
{
Ap_VouchBll bll = new Ap_VouchBll(StrAccID, AccYear, UserCode, plainPassword);
EntityAp_VouchHead entity = JsonConvert.DeserializeObject <EntityAp_VouchHead>(Entity);
int num = bll.GetAp_Vouch(entity.cVouchID);
if (num == 0)
{
return(ControllerHelp.GetReturnStr(1, "new"));
}
else
{
return(ControllerHelp.GetReturnStr(2, "old"));
}
}
break;
}
return(ControllerHelp.GetReturnStr(0, "GetModels(查询)中没有找到可对应的操作项"));
}
public override void DataSelect(int intKbn, object objList)
{
switch ((ExWebService.geWebServiceCallKbn)intKbn)
{
case _GetWebServiceCallKbn:
// 更新
if (objList != null)
{
_entity = (EntityCustomer)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 EntityCustomer();
SetBinding();
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.New;
}
this.utlID.txtID_IsReadOnly = true;
ExBackgroundWorker.DoWork_Focus(this.txtName, 10);
break;
default:
break;
}
}
private void SetBinding()
{
if (_entity == null)
{
_entity = new EntityCustomer();
}
// マスタコントロールPropertyChanged
_entity.PropertyChanged += this.utlInvoice.MstID_Changed;
_entity.PropertyChanged += this.utlZip.MstID_Changed;
_entity.PropertyChanged += this.utlSummingUp.MstID_Changed;
_entity.PropertyChanged += this.utlReceiptDivision.MstID_Changed;
_entity.PropertyChanged += this.utlGroup1.MstID_Changed;
_entity.PropertyChanged += this._PropertyChanged;
NumberConverter nmConvDecm0 = new NumberConverter();
#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 BindingAboutName = new Binding("_about_name");
BindingAboutName.Mode = BindingMode.TwoWay;
BindingAboutName.Source = _entity;
this.txtAdoutName.SetBinding(TextBox.TextProperty, BindingAboutName);
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 BindingStationName = new Binding("_station_name");
BindingStationName.Mode = BindingMode.TwoWay;
BindingStationName.Source = _entity;
this.txtStationName.SetBinding(TextBox.TextProperty, BindingStationName);
Binding BindingPostName = new Binding("_post_name");
BindingPostName.Mode = BindingMode.TwoWay;
BindingPostName.Source = _entity;
this.txtPostName.SetBinding(TextBox.TextProperty, BindingPostName);
Binding BindingPersonName = new Binding("_person_name");
BindingPersonName.Mode = BindingMode.TwoWay;
BindingPersonName.Source = _entity;
this.txtPersonName.SetBinding(TextBox.TextProperty, BindingPersonName);
Binding BindingTitleId = new Binding("_title_id");
BindingTitleId.Mode = BindingMode.TwoWay;
BindingTitleId.Source = _entity;
this.utlTitle.txtID.SetBinding(TextBox.TextProperty, BindingTitleId);
Binding BindingTitleName = new Binding("_title_name");
BindingTitleName.Mode = BindingMode.TwoWay;
BindingTitleName.Source = _entity;
this.utlTitle.txtNm.SetBinding(TextBox.TextProperty, BindingTitleName);
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 BindingInvoiceId = new Binding("_invoice_id");
BindingInvoiceId.Mode = BindingMode.TwoWay;
BindingInvoiceId.Source = _entity;
this.utlInvoice.txtID.SetBinding(TextBox.TextProperty, BindingInvoiceId);
Binding BindingInvoiceName = new Binding("_invoice_nm");
BindingInvoiceName.Mode = BindingMode.TwoWay;
BindingInvoiceName.Source = _entity;
this.utlInvoice.txtNm.SetBinding(TextBox.TextProperty, BindingInvoiceName);
Binding BindingBusinessDivisionId = new Binding("_business_division_id");
BindingBusinessDivisionId.Mode = BindingMode.TwoWay;
BindingBusinessDivisionId.Source = _entity;
this.utlBusiness.txtID.SetBinding(TextBox.TextProperty, BindingBusinessDivisionId);
Binding BindingBusinessDivisionName = new Binding("_business_division_nm");
BindingBusinessDivisionName.Mode = BindingMode.TwoWay;
BindingBusinessDivisionName.Source = _entity;
this.utlBusiness.txtNm.SetBinding(TextBox.TextProperty, BindingBusinessDivisionName);
Binding BindingUnitKindId = new Binding("_unit_kind_id");
BindingUnitKindId.Mode = BindingMode.TwoWay;
BindingUnitKindId.Source = _entity;
this.utlUnitKind.txtID.SetBinding(TextBox.TextProperty, BindingUnitKindId);
Binding BindingUnitKindName = new Binding("_unit_kind_nm");
BindingUnitKindName.Mode = BindingMode.TwoWay;
BindingUnitKindName.Source = _entity;
this.utlUnitKind.txtNm.SetBinding(TextBox.TextProperty, BindingUnitKindName);
Binding BindingCreditRate = new Binding("_credit_rate");
BindingCreditRate.Mode = BindingMode.TwoWay;
BindingCreditRate.Source = _entity;
this.txtCreditRate.SetBinding(TextBox.TextProperty, BindingCreditRate);
Binding BindingTaxChangeId = new Binding("_tax_change_id");
BindingTaxChangeId.Mode = BindingMode.TwoWay;
BindingTaxChangeId.Source = _entity;
this.utlTaxChange.txtID.SetBinding(TextBox.TextProperty, BindingTaxChangeId);
Binding BindingTaxChangeName = new Binding("_tax_change_nm");
BindingTaxChangeName.Mode = BindingMode.TwoWay;
BindingTaxChangeName.Source = _entity;
this.utlTaxChange.txtNm.SetBinding(TextBox.TextProperty, BindingTaxChangeName);
Binding BindingSummingUpGroupId = new Binding("_summing_up_group_id");
BindingSummingUpGroupId.Mode = BindingMode.TwoWay;
BindingSummingUpGroupId.Source = _entity;
this.utlSummingUp.txtID.SetBinding(TextBox.TextProperty, BindingSummingUpGroupId);
Binding BindingSummingUpGroupName = new Binding("_summing_up_group_nm");
BindingSummingUpGroupName.Mode = BindingMode.TwoWay;
BindingSummingUpGroupName.Source = _entity;
this.utlSummingUp.txtNm.SetBinding(TextBox.TextProperty, BindingSummingUpGroupName);
Binding BindigPriceFractionProcId = new Binding("_price_fraction_proc_id");
BindigPriceFractionProcId.Mode = BindingMode.TwoWay;
BindigPriceFractionProcId.Source = _entity;
this.utlPriceFractionProc.txtID.SetBinding(TextBox.TextProperty, BindigPriceFractionProcId);
Binding BindigPriceFractionProcName = new Binding("_price_fraction_proc_nm");
BindigPriceFractionProcName.Mode = BindingMode.TwoWay;
BindigPriceFractionProcName.Source = _entity;
this.utlPriceFractionProc.txtNm.SetBinding(TextBox.TextProperty, BindigPriceFractionProcName);
Binding BindigTaxFractionProcId = new Binding("_tax_fraction_proc_id");
BindigTaxFractionProcId.Mode = BindingMode.TwoWay;
BindigTaxFractionProcId.Source = _entity;
this.utlTaxFractionProc.txtID.SetBinding(TextBox.TextProperty, BindigTaxFractionProcId);
Binding BindigTaxFractionProcName = new Binding("_tax_fraction_proc_nm");
BindigTaxFractionProcName.Mode = BindingMode.TwoWay;
BindigTaxFractionProcName.Source = _entity;
this.utlTaxFractionProc.txtNm.SetBinding(TextBox.TextProperty, BindigTaxFractionProcName);
Binding BindigCreditLimitPrice = new Binding("_credit_limit_price");
BindigCreditLimitPrice.Mode = BindingMode.TwoWay;
BindigCreditLimitPrice.Source = _entity;
this.txtCreditLimitPrice.SetBinding(TextBox.TextProperty, BindigCreditLimitPrice);
this.txtCreditLimitPrice.OnFormatString();
Binding BindigSalesCreditPrice = new Binding("_sales_credit_price");
BindigSalesCreditPrice.Mode = BindingMode.TwoWay;
BindigSalesCreditPrice.Source = _entity;
this.txtSalesLimitPrice.SetBinding(TextBox.TextProperty, BindigSalesCreditPrice);
this.txtSalesLimitPrice.OnFormatString();
Binding BindigReceiptDivisionId = new Binding("_receipt_division_id");
BindigReceiptDivisionId.Mode = BindingMode.TwoWay;
BindigReceiptDivisionId.Source = _entity;
this.utlReceiptDivision.txtID.SetBinding(TextBox.TextProperty, BindigReceiptDivisionId);
Binding BindigReceiptDivisionName = new Binding("_receipt_division_nm");
BindigReceiptDivisionName.Mode = BindingMode.TwoWay;
BindigReceiptDivisionName.Source = _entity;
this.utlReceiptDivision.txtNm.SetBinding(TextBox.TextProperty, BindigReceiptDivisionName);
Binding BindigCollectCycleId = new Binding("_collect_cycle_id");
BindigCollectCycleId.Mode = BindingMode.TwoWay;
BindigCollectCycleId.Source = _entity;
this.utlCollectCycle.txtID.SetBinding(TextBox.TextProperty, BindigCollectCycleId);
Binding BindigCollectCycleName = new Binding("_collect_cycle_nm");
BindigCollectCycleName.Mode = BindingMode.TwoWay;
BindigCollectCycleName.Source = _entity;
this.utlCollectCycle.txtNm.SetBinding(TextBox.TextProperty, BindigCollectCycleName);
Binding BindigCollectDay = new Binding("_collect_day");
BindigCollectDay.Mode = BindingMode.TwoWay;
BindigCollectDay.Source = _entity;
this.txtCollectDay.SetBinding(TextBox.TextProperty, BindigCollectDay);
Binding BindigBillSite = new Binding("_bill_site");
BindigBillSite.Mode = BindingMode.TwoWay;
BindigBillSite.Source = _entity;
this.txtBillSite.SetBinding(TextBox.TextProperty, BindigBillSite);
Binding BindigGroup1Id = new Binding("_group1_id");
BindigGroup1Id.Mode = BindingMode.TwoWay;
BindigGroup1Id.Source = _entity;
this.utlGroup1.txtID.SetBinding(TextBox.TextProperty, BindigGroup1Id);
Binding BindigGroup1Name = new Binding("_group1_nm");
BindigGroup1Name.Mode = BindingMode.TwoWay;
BindigGroup1Name.Source = _entity;
this.utlGroup1.txtNm.SetBinding(TextBox.TextProperty, BindigGroup1Name);
Binding BindigDiaplayDivisionId = new Binding("_display_division_id");
BindigDiaplayDivisionId.Mode = BindingMode.TwoWay;
BindigDiaplayDivisionId.Source = _entity;
this.utlDisplay.txtID.SetBinding(TextBox.TextProperty, BindigDiaplayDivisionId);
Binding BindigDiaplayDivisionNm = new Binding("_display_division_nm");
BindigDiaplayDivisionNm.Mode = BindingMode.TwoWay;
BindigDiaplayDivisionNm.Source = _entity;
this.utlDisplay.txtNm.SetBinding(TextBox.TextProperty, BindigDiaplayDivisionNm);
Binding BindigMemo = new Binding("_memo");
BindigMemo.Mode = BindingMode.TwoWay;
BindigMemo.Source = _entity;
this.txtMemo.SetBinding(TextBox.TextProperty, BindigMemo);
#endregion
this.utlID.txtID.SetZeroToNullString();
this.utlTitle.txtID.SetZeroToNullString();
this.utlInvoice.txtID.SetZeroToNullString();
this.utlBusiness.txtID.SetZeroToNullString();
this.utlUnitKind.txtID.SetZeroToNullString();
this.utlTaxFractionProc.txtID.SetZeroToNullString();
this.utlSummingUp.txtID.SetZeroToNullString();
this.utlReceiptDivision.txtID.SetZeroToNullString();
this.utlCollectCycle.txtID.SetZeroToNullString();
this.utlPriceFractionProc.txtID.SetZeroToNullString();
this.utlTaxFractionProc.txtID.SetZeroToNullString();
this.utlGroup1.txtID.SetZeroToNullString();
this.utlInvoice.txtID.FormatToID();
this.txtCreditLimitPrice.OnFormatString();
this.txtSalesLimitPrice.OnFormatString();
if (ExCast.zCInt(_entity._id) == 0)
{
_entity._business_division_id = 1; // 取引区分 1:掛売上
_entity._unit_kind_id = 2; // 単価種類 2:売上単価
_entity._tax_change_id = (int)Common.geTaxChange.OUT_TAX_SUM; // 税転換 1:外税/伝票計
_entity._price_fraction_proc_id = 2; // 金額端数処理 2:切り上げ
_entity._tax_fraction_proc_id = 2; // 税端数処理 2:切り上げ
_entity._display_division_id = 1;
_entity._credit_rate = 100;
}
}
// F2ボタン(クリア) クリック
public override void btnF2_Click(object sender, RoutedEventArgs e)
{
// 初期化
_entity = null;
SetBinding();
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Init;
this.utlID.txtID_IsReadOnly = false;
this.utlID.txtID.Text = "";
ExBackgroundWorker.DoWork_Focus(this.utlID, 10);
// ロック解除
DataPgLock.gLockPg(PG_NM, "", (int)DataPgLock.geLockType.UnLock);
}
private void UpdateCustomer(int type, string Id, EntityCustomer entity)
{
try
{
svcCustomerClient svc = new svcCustomerClient();
svc.UpdateCustomerCompleted += new EventHandler<UpdateCustomerCompletedEventArgs>(this.UpdateCustomerCompleted);
svc.UpdateCustomerAsync(Common.gstrSessionString, type, Id, entity);
}
catch (Exception ex)
{
this.ProcessingDlgClose();
ExMessageBox.Show(CLASS_NM + ".UpdateCustomer" + Environment.NewLine + ex.ToString(), "エラー確認");
}
}
public override void DataSelect(int intKbn, object objList)
{
switch ((ExWebService.geWebServiceCallKbn)intKbn)
{
case _GetWebServiceCallKbn:
// 更新
if (objList != null)
{
_entity = (EntitySupplier)objList;
if (_entity.message != "" && _entity.message != null)
{
this.utlID.txtID.Text = "";
ExBackgroundWorker.DoWork_Focus(this.utlID, 10);
return;
}
else
{
ExVisualTreeHelper.SetEnabled(this.MainDetail, true);
// バインド反映
SetBinding();
if (_entity._lock_flg == 0)
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Upd;
}
else
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Sel;
}
}
}
// 新規
else
{
_entity = new EntitySupplier();
ExVisualTreeHelper.SetEnabled(this.MainDetail, true);
SetBinding();
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.New;
}
this.utlID.txtID_IsReadOnly = true;
this.utlCustomer.txtID_IsReadOnly = true;
ExBackgroundWorker.DoWork_Focus(this.txtName, 10);
break;
case ExWebService.geWebServiceCallKbn.GetCustomer:
// 更新
if (objList != null)
{
EntityCustomer entityCustomer = (EntityCustomer)objList;
if (string.IsNullOrEmpty(entityCustomer.message))
{
string _Id = ExCast.zNumZeroNothingFormat(this.utlID.txtID.Text.Trim());
string _Nm = this.utlID.txtNm.Text.Trim();
string _customerId = ExCast.zNumZeroNothingFormat(this.utlCustomer.txtID.Text.Trim());
string _customerNm = this.utlCustomer.txtNm.Text.Trim();
_entity = new EntitySupplier();
_entity._id = _Id;
_entity._customer_id = _customerId;
_entity._customer_nm = _customerNm;
_entity._name = entityCustomer._name;
_entity._kana = entityCustomer._kana;
_entity._about_name = entityCustomer._about_name;
//_entity._zip_code = entityCustomer._zip_code;
_entity._adress_city = entityCustomer._adress_city;
_entity._adress_town = entityCustomer._adress_town;
_entity._adress1 = entityCustomer._adress1;
_entity._adress2 = entityCustomer._adress2;
_entity._station_name = entityCustomer._station_name;
_entity._post_name = entityCustomer._post_name;
_entity._person_name = entityCustomer._person_name;
_entity._title_id = entityCustomer._title_id;
_entity._title_name = entityCustomer._title_name;
_entity._tel = entityCustomer._tel;
_entity._fax = entityCustomer._fax;
_entity._mail_adress = entityCustomer._mail_adress;
_entity._mobile_tel = entityCustomer._mobile_tel;
_entity._mobile_adress = entityCustomer._mobile_adress;
_entity._url = entityCustomer._url;
SetBinding();
return;
}
}
break;
default:
break;
}
}
