private void FixupCustomer(Customer previousValue) { if (IsDeserializing) { return; } if (previousValue != null && previousValue.SalesOrderHeaders.Contains(this)) { previousValue.SalesOrderHeaders.Remove(this); } if (Customer != null) { if (!Customer.SalesOrderHeaders.Contains(this)) { Customer.SalesOrderHeaders.Add(this); } CustomerID = Customer.CustomerID; } if (ChangeTracker.ChangeTrackingEnabled) { if (ChangeTracker.OriginalValues.ContainsKey("Customer") && (ChangeTracker.OriginalValues["Customer"] == Customer)) { ChangeTracker.OriginalValues.Remove("Customer"); } else { ChangeTracker.RecordOriginalValue("Customer", previousValue); } if (Customer != null && !Customer.ChangeTracker.ChangeTrackingEnabled) { Customer.StartTracking(); } } }
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } Model.Customer model = new Model.Customer(); model.GUID = new Guid(this.dataGridView1[0, this.dataGridView1.CurrentRow.Index].Value.ToString()); frmCustomer frm = new frmCustomer(model); frm.ShowDialog(frmMain.Main); }
public OperationStatus SaveCustomer(Customer customer) { return new CustomerRepository().SaveCustomer(customer); }
private void GetCustomerGroupAndSelected(Guid guid) { //获得所属客户组 BLL.Customer bllCustomer = new BLL.Customer(); BLL.CustomerGroup bllGroup = new BLL.CustomerGroup(); Model.Customer modelCustomer = new Model.Customer(); modelCustomer = bllCustomer.GetModel(guid); List<string> lst = new List<string>(); bllGroup.GetSelected(ref lst, modelCustomer.parentGUID); StringBuilder sb = new StringBuilder(); for (int i = lst.Count - 1; i > 0; i--) { sb.Append(lst[i]); sb.Append(this.cbxCustomerGroup.BranchSeparator); } sb.Append(lst[0]); this.cbxCustomerGroup.Text = sb.ToString(); this.cbxCustomerGroup.SelectedNode = (this.cbxCustomerGroup.Nodes.Find( modelCustomer.parentGUID.ToString(), true))[0]; cbxCustomerGroup_Leave(null, null); cbxName.SelectedValue = guid.ToString(); }
public OperationStatus SaveCustomer(Customer customer) { return _Repository.SaveCustomer(customer); }
private void btnOK_Click(object sender, EventArgs e) { errorProvider1.Clear(); if (string.IsNullOrEmpty(this.txtNO.Text.Trim())) { errorProvider1.SetError(txtNO, "客户编号不能为空!"); return; } if (string.IsNullOrEmpty(this.txtName.Text.Trim())) { errorProvider1.SetError(txtName, "客户名称不能为空!"); return; } if (!this.cbxCustomerGroup.ValidateText()) { errorProvider1.SetError(cbxCustomerGroup, "必须选择所属客户组!"); return; } BLL.Customer bll = new BLL.Customer(); Model.Customer model = new Model.Customer(); model.cNO = txtNO.Text.Substring(txtNO.Text.Length - 4); model.cName = txtName.Text.Trim(); model.parentGUID = new Guid(this.cbxCustomerGroup.SelectedNode.Name); if (cbxIsGov.Text != "政府") { model.isGov = false; } else { model.isGov = true; } model.trade = txtTrade.Text.Trim(); model.cMan = txtMan.Text.Trim(); model.Tel = txtTel.Text.Trim(); model.fax = txtFax.Text.Trim(); model.email = txtEmail.Text.Trim(); model.province = cbxProvince.Text; model.city = cbxCity.Text; model.district = cbxDistrict.Text; model.QQ = txtQQ.Text.Trim(); model.mode = txtMode.Text.Trim(); model.scope = txtScope.Text.Trim(); model.product = txtProduct.Text.Trim(); model.addresss = txtAddress.Text.Trim(); model.cStage = cbxStage.Text; model.cType = cbxType.Text; model.cLevel = cbxLevel.Text; model.cStatus = cbxStatus.Text; model.link1 = txtLink1.Text.Trim(); model.tel1 = txtTel1.Text.Trim(); model.link2 = txtLink2.Text.Trim(); model.tel2 = txtTel2.Text.Trim(); bool flg = false; try { if (this.Text == "新增客户信息") { flg = bll.Add(model); } else { model.GUID = _model.GUID; flg = bll.Update(model); } } catch (Exception ex) { string error = ex.Message; MessageBox.Show("系统出错,请重试!"); return; } if (flg) { MessageBox.Show("操作成功!"); } else { MessageBox.Show("操作失败!"); } if (((Control)sender).Name == "btnSave") { this.Close(); this.Dispose(); frmCustomer frm = new frmCustomer(_guid); frm.ShowDialog(frmMain.Main); } else { this.Close(); } //刷新激活的窗体 for (int i = 0; i < frmMain.Main.DockPanelMain.Contents.Count; i++) { if (frmMain.Main.DockPanelMain.Contents[i] is dockCustomer) { dockCustomer dock = (dockCustomer) frmMain.Main.DockPanelMain.Contents[i]; dock.GetData(); } } }
/// <summary> /// 获得数据列表 /// </summary> public List<CustomerService.Model.Customer> DataTableToList(DataTable dt) { List<CustomerService.Model.Customer> modelList = new List<CustomerService.Model.Customer>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { CustomerService.Model.Customer model; for (int n = 0; n < rowsCount; n++) { model = new CustomerService.Model.Customer(); if(dt.Rows[n]["GUID"]!=null && dt.Rows[n]["GUID"].ToString()!="") { model.GUID=new Guid(dt.Rows[n]["GUID"].ToString()); } if(dt.Rows[n]["cNO"]!=null && dt.Rows[n]["cNO"].ToString()!="") { model.cNO=dt.Rows[n]["cNO"].ToString(); } if(dt.Rows[n]["parentGUID"]!=null && dt.Rows[n]["parentGUID"].ToString()!="") { model.parentGUID=new Guid(dt.Rows[n]["parentGUID"].ToString()); } if(dt.Rows[n]["cName"]!=null && dt.Rows[n]["cName"].ToString()!="") { model.cName=dt.Rows[n]["cName"].ToString(); } if(dt.Rows[n]["cMan"]!=null && dt.Rows[n]["cMan"].ToString()!="") { model.cMan=dt.Rows[n]["cMan"].ToString(); } if(dt.Rows[n]["Tel"]!=null && dt.Rows[n]["Tel"].ToString()!="") { model.Tel=dt.Rows[n]["Tel"].ToString(); } if(dt.Rows[n]["isGov"]!=null && dt.Rows[n]["isGov"].ToString()!="") { if((dt.Rows[n]["isGov"].ToString()=="1")||(dt.Rows[n]["isGov"].ToString().ToLower()=="true")) { model.isGov=true; } else { model.isGov=false; } } if(dt.Rows[n]["trade"]!=null && dt.Rows[n]["trade"].ToString()!="") { model.trade=dt.Rows[n]["trade"].ToString(); } if(dt.Rows[n]["deptUp"]!=null && dt.Rows[n]["deptUp"].ToString()!="") { model.deptUp=dt.Rows[n]["deptUp"].ToString(); } if(dt.Rows[n]["cType"]!=null && dt.Rows[n]["cType"].ToString()!="") { model.cType=dt.Rows[n]["cType"].ToString(); } if(dt.Rows[n]["cStage"]!=null && dt.Rows[n]["cStage"].ToString()!="") { model.cStage=dt.Rows[n]["cStage"].ToString(); } if(dt.Rows[n]["cStatus"]!=null && dt.Rows[n]["cStatus"].ToString()!="") { model.cStatus=dt.Rows[n]["cStatus"].ToString(); } if(dt.Rows[n]["cLevel"]!=null && dt.Rows[n]["cLevel"].ToString()!="") { model.cLevel=dt.Rows[n]["cLevel"].ToString(); } if(dt.Rows[n]["province"]!=null && dt.Rows[n]["province"].ToString()!="") { model.province=dt.Rows[n]["province"].ToString(); } if(dt.Rows[n]["city"]!=null && dt.Rows[n]["city"].ToString()!="") { model.city=dt.Rows[n]["city"].ToString(); } if(dt.Rows[n]["district"]!=null && dt.Rows[n]["district"].ToString()!="") { model.district=dt.Rows[n]["district"].ToString(); } if(dt.Rows[n]["fax"]!=null && dt.Rows[n]["fax"].ToString()!="") { model.fax=dt.Rows[n]["fax"].ToString(); } if(dt.Rows[n]["addresss"]!=null && dt.Rows[n]["addresss"].ToString()!="") { model.addresss=dt.Rows[n]["addresss"].ToString(); } if(dt.Rows[n]["zip"]!=null && dt.Rows[n]["zip"].ToString()!="") { model.zip=dt.Rows[n]["zip"].ToString(); } if(dt.Rows[n]["netSet"]!=null && dt.Rows[n]["netSet"].ToString()!="") { model.netSet=dt.Rows[n]["netSet"].ToString(); } if(dt.Rows[n]["email"]!=null && dt.Rows[n]["email"].ToString()!="") { model.email=dt.Rows[n]["email"].ToString(); } if(dt.Rows[n]["QQ"]!=null && dt.Rows[n]["QQ"].ToString()!="") { model.QQ=dt.Rows[n]["QQ"].ToString(); } if(dt.Rows[n]["mode"]!=null && dt.Rows[n]["mode"].ToString()!="") { model.mode=dt.Rows[n]["mode"].ToString(); } if(dt.Rows[n]["scope"]!=null && dt.Rows[n]["scope"].ToString()!="") { model.scope=dt.Rows[n]["scope"].ToString(); } if(dt.Rows[n]["product"]!=null && dt.Rows[n]["product"].ToString()!="") { model.product=dt.Rows[n]["product"].ToString(); } if(dt.Rows[n]["opponent"]!=null && dt.Rows[n]["opponent"].ToString()!="") { model.opponent=dt.Rows[n]["opponent"].ToString(); } if(dt.Rows[n]["credit"]!=null && dt.Rows[n]["credit"].ToString()!="") { model.credit=dt.Rows[n]["credit"].ToString(); } if(dt.Rows[n]["link1"]!=null && dt.Rows[n]["link1"].ToString()!="") { model.link1=dt.Rows[n]["link1"].ToString(); } if(dt.Rows[n]["dept1"]!=null && dt.Rows[n]["dept1"].ToString()!="") { model.dept1=dt.Rows[n]["dept1"].ToString(); } if(dt.Rows[n]["job1"]!=null && dt.Rows[n]["job1"].ToString()!="") { model.job1=dt.Rows[n]["job1"].ToString(); } if(dt.Rows[n]["tel1"]!=null && dt.Rows[n]["tel1"].ToString()!="") { model.tel1=dt.Rows[n]["tel1"].ToString(); } if(dt.Rows[n]["phone1"]!=null && dt.Rows[n]["phone1"].ToString()!="") { model.phone1=dt.Rows[n]["phone1"].ToString(); } if(dt.Rows[n]["link2"]!=null && dt.Rows[n]["link2"].ToString()!="") { model.link2=dt.Rows[n]["link2"].ToString(); } if(dt.Rows[n]["dept2"]!=null && dt.Rows[n]["dept2"].ToString()!="") { model.dept2=dt.Rows[n]["dept2"].ToString(); } if(dt.Rows[n]["job2"]!=null && dt.Rows[n]["job2"].ToString()!="") { model.job2=dt.Rows[n]["job2"].ToString(); } if(dt.Rows[n]["tel2"]!=null && dt.Rows[n]["tel2"].ToString()!="") { model.tel2=dt.Rows[n]["tel2"].ToString(); } if(dt.Rows[n]["phone2"]!=null && dt.Rows[n]["phone2"].ToString()!="") { model.phone2=dt.Rows[n]["phone2"].ToString(); } if(dt.Rows[n]["mapImg"]!=null && dt.Rows[n]["mapImg"].ToString()!="") { model.mapImg=(byte[])dt.Rows[n]["mapImg"]; } if(dt.Rows[n]["drive"]!=null && dt.Rows[n]["drive"].ToString()!="") { model.drive=dt.Rows[n]["drive"].ToString(); } if(dt.Rows[n]["bus"]!=null && dt.Rows[n]["bus"].ToString()!="") { model.bus=dt.Rows[n]["bus"].ToString(); } if(dt.Rows[n]["createDate"]!=null && dt.Rows[n]["createDate"].ToString()!="") { model.createDate=DateTime.Parse(dt.Rows[n]["createDate"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 获得数据列表 /// </summary> public List <CustomerService.Model.Customer> DataTableToList(DataTable dt) { List <CustomerService.Model.Customer> modelList = new List <CustomerService.Model.Customer>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { CustomerService.Model.Customer model; for (int n = 0; n < rowsCount; n++) { model = new CustomerService.Model.Customer(); if (dt.Rows[n]["GUID"] != null && dt.Rows[n]["GUID"].ToString() != "") { model.GUID = new Guid(dt.Rows[n]["GUID"].ToString()); } if (dt.Rows[n]["cNO"] != null && dt.Rows[n]["cNO"].ToString() != "") { model.cNO = dt.Rows[n]["cNO"].ToString(); } if (dt.Rows[n]["parentGUID"] != null && dt.Rows[n]["parentGUID"].ToString() != "") { model.parentGUID = new Guid(dt.Rows[n]["parentGUID"].ToString()); } if (dt.Rows[n]["cName"] != null && dt.Rows[n]["cName"].ToString() != "") { model.cName = dt.Rows[n]["cName"].ToString(); } if (dt.Rows[n]["cMan"] != null && dt.Rows[n]["cMan"].ToString() != "") { model.cMan = dt.Rows[n]["cMan"].ToString(); } if (dt.Rows[n]["Tel"] != null && dt.Rows[n]["Tel"].ToString() != "") { model.Tel = dt.Rows[n]["Tel"].ToString(); } if (dt.Rows[n]["isGov"] != null && dt.Rows[n]["isGov"].ToString() != "") { if ((dt.Rows[n]["isGov"].ToString() == "1") || (dt.Rows[n]["isGov"].ToString().ToLower() == "true")) { model.isGov = true; } else { model.isGov = false; } } if (dt.Rows[n]["trade"] != null && dt.Rows[n]["trade"].ToString() != "") { model.trade = dt.Rows[n]["trade"].ToString(); } if (dt.Rows[n]["deptUp"] != null && dt.Rows[n]["deptUp"].ToString() != "") { model.deptUp = dt.Rows[n]["deptUp"].ToString(); } if (dt.Rows[n]["cType"] != null && dt.Rows[n]["cType"].ToString() != "") { model.cType = dt.Rows[n]["cType"].ToString(); } if (dt.Rows[n]["cStage"] != null && dt.Rows[n]["cStage"].ToString() != "") { model.cStage = dt.Rows[n]["cStage"].ToString(); } if (dt.Rows[n]["cStatus"] != null && dt.Rows[n]["cStatus"].ToString() != "") { model.cStatus = dt.Rows[n]["cStatus"].ToString(); } if (dt.Rows[n]["cLevel"] != null && dt.Rows[n]["cLevel"].ToString() != "") { model.cLevel = dt.Rows[n]["cLevel"].ToString(); } if (dt.Rows[n]["province"] != null && dt.Rows[n]["province"].ToString() != "") { model.province = dt.Rows[n]["province"].ToString(); } if (dt.Rows[n]["city"] != null && dt.Rows[n]["city"].ToString() != "") { model.city = dt.Rows[n]["city"].ToString(); } if (dt.Rows[n]["district"] != null && dt.Rows[n]["district"].ToString() != "") { model.district = dt.Rows[n]["district"].ToString(); } if (dt.Rows[n]["fax"] != null && dt.Rows[n]["fax"].ToString() != "") { model.fax = dt.Rows[n]["fax"].ToString(); } if (dt.Rows[n]["addresss"] != null && dt.Rows[n]["addresss"].ToString() != "") { model.addresss = dt.Rows[n]["addresss"].ToString(); } if (dt.Rows[n]["zip"] != null && dt.Rows[n]["zip"].ToString() != "") { model.zip = dt.Rows[n]["zip"].ToString(); } if (dt.Rows[n]["netSet"] != null && dt.Rows[n]["netSet"].ToString() != "") { model.netSet = dt.Rows[n]["netSet"].ToString(); } if (dt.Rows[n]["email"] != null && dt.Rows[n]["email"].ToString() != "") { model.email = dt.Rows[n]["email"].ToString(); } if (dt.Rows[n]["QQ"] != null && dt.Rows[n]["QQ"].ToString() != "") { model.QQ = dt.Rows[n]["QQ"].ToString(); } if (dt.Rows[n]["mode"] != null && dt.Rows[n]["mode"].ToString() != "") { model.mode = dt.Rows[n]["mode"].ToString(); } if (dt.Rows[n]["scope"] != null && dt.Rows[n]["scope"].ToString() != "") { model.scope = dt.Rows[n]["scope"].ToString(); } if (dt.Rows[n]["product"] != null && dt.Rows[n]["product"].ToString() != "") { model.product = dt.Rows[n]["product"].ToString(); } if (dt.Rows[n]["opponent"] != null && dt.Rows[n]["opponent"].ToString() != "") { model.opponent = dt.Rows[n]["opponent"].ToString(); } if (dt.Rows[n]["credit"] != null && dt.Rows[n]["credit"].ToString() != "") { model.credit = dt.Rows[n]["credit"].ToString(); } if (dt.Rows[n]["link1"] != null && dt.Rows[n]["link1"].ToString() != "") { model.link1 = dt.Rows[n]["link1"].ToString(); } if (dt.Rows[n]["dept1"] != null && dt.Rows[n]["dept1"].ToString() != "") { model.dept1 = dt.Rows[n]["dept1"].ToString(); } if (dt.Rows[n]["job1"] != null && dt.Rows[n]["job1"].ToString() != "") { model.job1 = dt.Rows[n]["job1"].ToString(); } if (dt.Rows[n]["tel1"] != null && dt.Rows[n]["tel1"].ToString() != "") { model.tel1 = dt.Rows[n]["tel1"].ToString(); } if (dt.Rows[n]["phone1"] != null && dt.Rows[n]["phone1"].ToString() != "") { model.phone1 = dt.Rows[n]["phone1"].ToString(); } if (dt.Rows[n]["link2"] != null && dt.Rows[n]["link2"].ToString() != "") { model.link2 = dt.Rows[n]["link2"].ToString(); } if (dt.Rows[n]["dept2"] != null && dt.Rows[n]["dept2"].ToString() != "") { model.dept2 = dt.Rows[n]["dept2"].ToString(); } if (dt.Rows[n]["job2"] != null && dt.Rows[n]["job2"].ToString() != "") { model.job2 = dt.Rows[n]["job2"].ToString(); } if (dt.Rows[n]["tel2"] != null && dt.Rows[n]["tel2"].ToString() != "") { model.tel2 = dt.Rows[n]["tel2"].ToString(); } if (dt.Rows[n]["phone2"] != null && dt.Rows[n]["phone2"].ToString() != "") { model.phone2 = dt.Rows[n]["phone2"].ToString(); } if (dt.Rows[n]["mapImg"] != null && dt.Rows[n]["mapImg"].ToString() != "") { model.mapImg = (byte[])dt.Rows[n]["mapImg"]; } if (dt.Rows[n]["drive"] != null && dt.Rows[n]["drive"].ToString() != "") { model.drive = dt.Rows[n]["drive"].ToString(); } if (dt.Rows[n]["bus"] != null && dt.Rows[n]["bus"].ToString() != "") { model.bus = dt.Rows[n]["bus"].ToString(); } if (dt.Rows[n]["createDate"] != null && dt.Rows[n]["createDate"].ToString() != "") { model.createDate = DateTime.Parse(dt.Rows[n]["createDate"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(CustomerService.Model.Customer model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(CustomerService.Model.Customer model) { return(dal.Add(model)); }