/// <summary> /// 刷新数据 /// </summary> private void RefreshControl() { P_ProvidersBaseInfo baseInfo = m_providerServer.GetBaseInfoByCode(m_providerCode, out m_error); if (baseInfo != null) { txtAddress.Text = baseInfo.Address; txtBankCode.Text = baseInfo.BankCode; txtCode.Text = baseInfo.ProviderCode; txtCompanyWeb.Text = baseInfo.CompanyWeb; txtEmail.Text = baseInfo.Email; txtFaxNo.Text = baseInfo.FaxNo; txtLegalRepresenta.Text = baseInfo.LegalRepresenta; txtOpenBank.Text = baseInfo.OpenBank; txtOpenInvoiceNumber.Text = baseInfo.OpenInvoiceNumber; txtPostcode.Text = baseInfo.Postcode; txtProviderCode.Text = baseInfo.ProviderCode; txtProviderName.Text = baseInfo.ProviderName; txtRecord.Text = UniversalFunction.GetPersonnelName(baseInfo.Record); txtRecordDate.Text = baseInfo.RecordDate.ToString(); txtRemark.Text = baseInfo.Remark; txtShortName.Text = baseInfo.ShortName; txtTaxpayerNumber.Text = baseInfo.TaxpayerNumber; cmbStatus.Text = baseInfo.Status; } DataTable linkManDt = m_providerServer.GetLinkManByCode(m_providerCode); if (linkManDt != null && linkManDt.Rows.Count > 0) { dgvLinkMan.DataSource = linkManDt; } DataTable principalDt = m_providerServer.GetProviderPrincipal(m_providerCode); if (principalDt != null && principalDt.Rows.Count > 0) { dgvDutyOfficer.DataSource = principalDt; } }
/// <summary> /// 添加供应商档案 /// </summary> /// <param name="providers">供应商档案数据集</param> /// <param name="dtLinkMan">供应商联系人数据集</param> /// <param name="dtPersonnel">供应商责任人数据集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool AddProvidersInfo(P_ProvidersBaseInfo providers, List <ProviderPrincipal> dtPersonnel, List <P_ProviderLinkMan> dtLinkMan, out string error) { error = ""; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var result = from a in dataContxt.P_ProvidersBaseInfo where a.ProviderCode == providers.ProviderCode && a.ProviderName == providers.ProviderName select a; if (result.Count() == 0) { dataContxt.P_ProvidersBaseInfo.InsertOnSubmit(providers); } else if (result.Count() == 1) { P_ProvidersBaseInfo lnqInfo = result.Single(); lnqInfo.Address = providers.Address; lnqInfo.BankCode = providers.BankCode; lnqInfo.CompanyWeb = providers.CompanyWeb; lnqInfo.Email = providers.Email; lnqInfo.FaxNo = providers.FaxNo; lnqInfo.IsPapers = providers.IsPapers; lnqInfo.LegalRepresenta = providers.LegalRepresenta; lnqInfo.OpenBank = providers.OpenBank; lnqInfo.OpenInvoiceNumber = providers.OpenInvoiceNumber; lnqInfo.Postcode = providers.Postcode; lnqInfo.Property = providers.Property; lnqInfo.ProviderType = providers.ProviderType; lnqInfo.Record = BasicInfo.LoginID; lnqInfo.RecordDate = ServerTime.Time; lnqInfo.Remark = providers.Remark; lnqInfo.Status = "潜在供应商"; lnqInfo.TaxpayerNumber = providers.TaxpayerNumber; lnqInfo.Annex = providers.Annex; lnqInfo.AnnexName = providers.AnnexName; } //添加责任人 if (DeletePrincipal(providers.ProviderCode, out error)) { foreach (ProviderPrincipal item in dtPersonnel) { dataContxt.ProviderPrincipal.InsertOnSubmit(item); } dataContxt.SubmitChanges(); } //添加联系人 if (DeleteLinkMan(providers.ProviderCode, out error)) { foreach (P_ProviderLinkMan item in dtLinkMan) { dataContxt.P_ProviderLinkMan.InsertOnSubmit(item); } } dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 批量插入供应商档案 /// </summary> /// <param name="providers">供应商档案列表</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>插入成功返回True,插入失败返回False</returns> public bool InsertProvidersInfo(DataTable providers, out string error) { error = null; string strTemp = ""; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; for (int i = 0; i < providers.Rows.Count; i++) { if (providers.Rows[i]["供应商简码"].ToString().Trim() != "") { strTemp = providers.Rows[i]["供应商简码"].ToString().Trim(); string code = strTemp; var result = from a in dataContxt.P_ProvidersBaseInfo where a.ProviderCode == code && a.ProviderName == providers.Rows[i]["供应商全称"].ToString().Trim() select a; if (result.Count() == 0) { P_ProvidersBaseInfo providersList = new P_ProvidersBaseInfo(); providersList.ProviderCode = code; providersList.ProviderName = providers.Rows[i]["供应商全称"] == DBNull.Value ? "" : providers.Rows[i]["供应商全称"].ToString().Trim(); providersList.Address = providers.Rows[i]["地址"] == DBNull.Value ? "" : providers.Rows[i]["地址"].ToString().Trim(); providersList.BankCode = providers.Rows[i]["帐号"] == DBNull.Value ? "" : providers.Rows[i]["帐号"].ToString().Trim(); providersList.Email = providers.Rows[i]["电子邮件"] == DBNull.Value ? "" : providers.Rows[i]["电子邮件"].ToString().Trim(); providersList.FaxNo = providers.Rows[i]["传真"] == DBNull.Value ? "" : providers.Rows[i]["传真"].ToString().Trim(); providersList.LegalRepresenta = "";//法人代表 providersList.OpenBank = providers.Rows[i]["开户行"] == DBNull.Value ? "" : providers.Rows[i]["开户行"].ToString().Trim(); providersList.OpenInvoiceNumber = providers.Rows[i]["开具发票电话号码"] == DBNull.Value ? "" : providers.Rows[i]["开具发票电话号码"].ToString().Trim(); providersList.Postcode = providers.Rows[i]["邮编"] == DBNull.Value ? "" : providers.Rows[i]["邮编"].ToString().Trim(); providersList.Property = "";//公司性质 providersList.Record = BasicInfo.LoginID; providersList.RecordDate = ServerTime.Time; providersList.Remark = ""; //备注 providersList.ShortName = ""; //简称 providersList.Status = "合格供应商"; //供应商状态 providersList.TaxpayerNumber = providers.Rows[i]["纳税人识别号"] == DBNull.Value ? "" : providers.Rows[i]["纳税人识别号"].ToString().Trim(); providersList.PY = UniversalFunction.GetPYWBCode(providers.Rows[i]["供应商全称"].ToString().Trim(), "PY"); providersList.WB = UniversalFunction.GetPYWBCode(providers.Rows[i]["供应商全称"].ToString().Trim(), "WB"); dataContxt.P_ProvidersBaseInfo.InsertOnSubmit(providersList); dataContxt.SubmitChanges(); } } if (providers.Rows[i]["零件图号"].ToString().Trim() != "") { var resultList = from a in dataContxt.P_ProviderGoods where a.GoodsCode == providers.Rows[i]["零件图号"].ToString().Trim() && a.GoodsName == providers.Rows[i]["零件名称"].ToString().Trim() && a.Spec == providers.Rows[i]["规格"].ToString().Trim() && a.ProviderCode == strTemp select a; if (resultList.Count() == 0) { P_ProviderGoods goods = new P_ProviderGoods(); goods.GoodsCode = providers.Rows[i]["零件图号"] == DBNull.Value ? "" : providers.Rows[i]["零件图号"].ToString().Trim(); goods.GoodsName = providers.Rows[i]["零件名称"] == DBNull.Value ? "" : providers.Rows[i]["零件名称"].ToString().Trim(); goods.Spec = providers.Rows[i]["规格"] == DBNull.Value ? "" : providers.Rows[i]["规格"].ToString().Trim(); goods.ProviderCode = strTemp; dataContxt.P_ProviderGoods.InsertOnSubmit(goods); dataContxt.SubmitChanges(); } } if (providers.Rows[i]["联系人"].ToString().Trim() != "") { var resultLinkMan = from a in dataContxt.P_ProviderLinkMan where a.Name == providers.Rows[i]["联系人"].ToString().Trim() && a.ProviderCode == strTemp select a; if (resultLinkMan.Count() == 0) { P_ProviderLinkMan linkMan = new P_ProviderLinkMan(); linkMan.Mobilephone = providers.Rows[i]["手机"] == DBNull.Value ? "" : providers.Rows[i]["手机"].ToString().Trim(); linkMan.Name = providers.Rows[i]["联系人"] == DBNull.Value ? "" : providers.Rows[i]["联系人"].ToString().Trim(); linkMan.Position = providers.Rows[i]["职务"] == DBNull.Value ? "" : providers.Rows[i]["职务"].ToString().Trim(); linkMan.ProviderCode = strTemp; linkMan.Telephone = providers.Rows[i]["联系电话"] == DBNull.Value ? "" : providers.Rows[i]["联系电话"].ToString().Trim(); dataContxt.P_ProviderLinkMan.InsertOnSubmit(linkMan); dataContxt.SubmitChanges(); } } } dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message + "供应商简码" + strTemp; return(false); } }
/// <summary> /// 获取数据 /// </summary> /// <returns>获取成功返回true,否则false</returns> public bool GetBaseInfo() { m_listLinkMan = new List <P_ProviderLinkMan>(); m_listPrincipal = new List <ProviderPrincipal>(); m_listProvidersGoods = new List <P_ProviderGoods>(); m_providerBaseInfo = new P_ProvidersBaseInfo(); m_providerBaseInfo.Address = txtAddress.Text; if (m_picbyte != null) { m_providerBaseInfo.Annex = m_picbyte; m_providerBaseInfo.AnnexName = m_pathName; } m_providerBaseInfo.BankCode = txtBankCode.Text; m_providerBaseInfo.CompanyWeb = txtCompanyWeb.Text; m_providerBaseInfo.Email = txtEmail.Text; m_providerBaseInfo.FaxNo = txtFaxNo.Text; m_providerBaseInfo.IsPapers = cmbIsPapers.Text == "是" ? true : false; m_providerBaseInfo.LegalRepresenta = txtLegalRepresenta.Text; m_providerBaseInfo.OpenBank = txtOpenBank.Text; m_providerBaseInfo.OpenInvoiceNumber = txtOpenInvoiceNumber.Text; m_providerBaseInfo.Postcode = txtPostcode.Text; m_providerBaseInfo.Property = cmbProperty.Text; m_providerBaseInfo.ProviderCode = txtProviderCode.Text; m_providerBaseInfo.ProviderName = txtProviderName.Text; m_providerBaseInfo.ProviderType = cmbProviderType.Text; m_providerBaseInfo.Record = BasicInfo.LoginID; m_providerBaseInfo.RecordDate = ServerTime.Time; m_providerBaseInfo.Remark = txtRemark.Text; m_providerBaseInfo.ShortName = txtShortName.Text; m_providerBaseInfo.Status = cmbStatus.Text; m_providerBaseInfo.TaxpayerNumber = txtTaxpayerNumber.Text; for (int i = 0; i < dgvDutyOfficer.Rows.Count; i++) { ProviderPrincipal principal = new ProviderPrincipal(); principal.IsMainDuty = Convert.ToBoolean(dgvDutyOfficer.Rows[i].Cells["是否主要责任人"].Value); principal.PrincipalWorkId = dgvDutyOfficer.Rows[i].Cells["员工编号"].Value.ToString(); principal.Provider = txtProviderCode.Text; m_listPrincipal.Add(principal); } for (int i = 0; i < dgvGoods.Rows.Count; i++) { P_ProviderGoods goodsInfo = new P_ProviderGoods(); goodsInfo.GoodsCode = dgvGoods.Rows[i].Cells["图号型号"].Value.ToString(); goodsInfo.GoodsName = dgvGoods.Rows[i].Cells["物品名称"].Value.ToString(); goodsInfo.Spec = dgvGoods.Rows[i].Cells["规格"].Value.ToString(); goodsInfo.Price = Convert.ToDecimal(dgvGoods.Rows[i].Cells["购买价"].Value); goodsInfo.Quote = Convert.ToDecimal(dgvGoods.Rows[i].Cells["报价"].Value); goodsInfo.Remark = dgvGoods.Rows[i].Cells["备注"].Value.ToString(); goodsInfo.Status = dgvGoods.Rows[i].Cells["零件状态"].Value.ToString(); goodsInfo.Type = m_providerServer.GetGoodsType(dgvGoods.Rows[i].Cells["零件类别"].Value.ToString()).ID; m_listProvidersGoods.Add(goodsInfo); } for (int i = 0; i < dgvLinkMan.Rows.Count; i++) { P_ProviderLinkMan linkman = new P_ProviderLinkMan(); linkman.Email = (string)dgvLinkMan.Rows[i].Cells["电子邮件地址"].Value; linkman.FaxNo = (string)dgvLinkMan.Rows[i].Cells["传真号码"].Value; linkman.Mobilephone = (string)dgvLinkMan.Rows[i].Cells["手机号码"].Value; linkman.Name = dgvLinkMan.Rows[i].Cells["姓名"].Value.ToString(); linkman.Position = (string)dgvLinkMan.Rows[i].Cells["职位"].Value; linkman.ProviderCode = txtProviderCode.Text; linkman.Remark = (string)dgvLinkMan.Rows[i].Cells["备注"].Value; linkman.Sex = (string)dgvLinkMan.Rows[i].Cells["性别"].Value; linkman.Telephone = (string)dgvLinkMan.Rows[i].Cells["电话号码"].Value; m_listLinkMan.Add(linkman); } return(true); }