/// <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);
}
