/// <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);
}
/// <summary>
/// 添加/修改部门信息表
/// </summary>
/// <param name="providerCode">供应商编码</param>
/// <param name="providerName">供应商名称</param>
/// <param name="shortName">简称</param>
/// <param name="personnel">责任人</param>
/// <param name="isOdd">是否关联责任人</param>
/// <param name="isUse">是否在用</param>
/// <param name="isMainDuty">是否为主要责任人</param>
/// <param name="returnBill">部门信息表</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <param name="isInternalSupplier">是否为内部供应商</param>
/// <param name="clearingForm">挂账方式</param>
/// <param name="yearMonth">追溯年月</param>
/// <returns>返回是否成功添加/修改部门信息表</returns>
public bool AddProvider(string providerCode, string providerName, string shortName,
string personnel, out IQueryable <View_Provider> returnBill, out string error,
bool isOdd, bool isUse, bool isMainDuty, bool isInternalSupplier, string clearingForm, string yearMonth)
{
returnBill = null;
error = null;
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
try
{
if (clearingForm == "用量" && yearMonth.Trim().Length != 6)
{
throw new Exception("【用量挂账】需填写【追溯年月】");
}
Table <Provider> billtable = dataContxt.GetTable <Provider>();
Table <ProviderPrincipal> billPrincipalTable = dataContxt.GetTable <ProviderPrincipal>();
var billGather = from c in billtable
where c.ProviderCode == providerCode
select c;
var billPrincipal = from c in billPrincipalTable
where c.Provider == providerCode && c.PrincipalWorkId == personnel
select c;
int intSameNoteCount = billGather.Count <Provider>();
int intDiffrentNodteCount = billPrincipal.Count <ProviderPrincipal>();
if (intSameNoteCount != 0 && intDiffrentNodteCount != 0)
{
error = "不可重复添加相同关系表";
return(false);
}
else
{
if (intSameNoteCount == 0)
{
Provider tableProvider = new Provider();
tableProvider.ProviderCode = providerCode;
tableProvider.ProviderName = providerName;
tableProvider.ShortName = shortName;
tableProvider.PY = UniversalFunction.GetPYWBCode(providerName, "PY");
tableProvider.WB = UniversalFunction.GetPYWBCode(providerName, "WB");
tableProvider.IsUse = isUse;
tableProvider.IsOddProvider = isOdd;
tableProvider.IsInternalSupplier = isInternalSupplier;
tableProvider.ClearingForm = clearingForm;
tableProvider.AscendYearMonth = clearingForm == "入库" ? null : yearMonth;
dataContxt.Provider.InsertOnSubmit(tableProvider);
dataContxt.SubmitChanges();
}
#region 添加到关系表中
ProviderPrincipal tableProviderPrincipal = new ProviderPrincipal();
tableProviderPrincipal.Provider = providerCode;
tableProviderPrincipal.PrincipalWorkId = personnel;
tableProviderPrincipal.IsMainDuty = isMainDuty;
dataContxt.ProviderPrincipal.InsertOnSubmit(tableProviderPrincipal);
dataContxt.SubmitChanges();
#endregion
GetAllProvider(out returnBill, out error);
}
return(true);
}
catch (Exception err)
{
return(SetReturnError1(err, out returnBill, out error));
}
}
