/// <summary>
/// 查找物品
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFindCode_Click(object sender, EventArgs e)
{
try
{
ClearControl();
FormQueryInfo form = QueryInfoDialog.GetOrderFormGoodsDialog(m_billInfo.OrderBill_ID, true);
IOrderFormInfoServer serviceOrderForm = ServerModuleFactory.GetServerModule <IOrderFormInfoServer>();
View_B_OrderFormInfo orderInfo = serviceOrderForm.GetOrderFormInfo(m_billInfo.OrderBill_ID);
if (form != null && form.ShowDialog() == DialogResult.OK)
{
txtCode.Text = (string)form.GetDataItem("图号型号");
txtName.Text = (string)form.GetDataItem("物品名称");
txtSpec.Text = (string)form.GetDataItem("规格");
IBargainGoodsServer serviceGoodsInfo = ServerModuleFactory.GetServerModule <IBargainGoodsServer>();
numUnitPrice.Value = serviceGoodsInfo.GetGoodsUnitPrice(m_billInfo.OrderBill_ID, Convert.ToInt32(form.GetDataItem("物品ID")), orderInfo.供货单位);
numGoodsAmount.Value = (decimal)form.GetDataItem("订货数量");
View_F_GoodsPlanCost planCost = GetBasicGoodsInfo(txtCode.Text, txtName.Text, txtSpec.Text, numUnitPrice.Value);
if (planCost != null)
{
cmbUnit.Text = planCost.单位;
numPlanUnitPrice.Value = planCost.单价;
}
}
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
}
/// <summary>
/// 删除合同信息
/// </summary>
/// <param name="bargainNumber">合同编号</param>
/// <param name="returnBargainInfo">返回查询到的合同信息</param>
/// <param name="error">错误信息, 没有则为null</param>
/// <returns>操作是否成功的标志</returns>
public bool DeleteBargainInfo(string bargainNumber, out IQueryResult returnBargainInfo, out string error)
{
error = null;
returnBargainInfo = null;
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
IBargainGoodsServer goodsServer = ServerModuleFactory.GetServerModule <IBargainGoodsServer>();
IQueryable <View_B_BargainGoods> returnBargainGoods;
if (!goodsServer.GetBargainGoods(bargainNumber, out returnBargainGoods, out error))
{
return(false);
}
#region 检查此合同的订单信息
IOrderFormInfoServer orderFormServer = ServerModuleFactory.GetServerModule <IOrderFormInfoServer>();
if (orderFormServer.GetOrderFormCollection(bargainNumber).Count() > 0)
{
error = string.Format("合同 [{0}] 还包含有订单信息无法进行删除，请将所有此合同包含的订单信息全部删除后才能进行此操作！",
bargainNumber);
return(false);
}
#endregion
if (returnBargainGoods != null && returnBargainGoods.Count() > 0)
{
error = string.Format("合同 [{0}] 还包含有零件信息无法进行删除，请将所有此合同包含的零件信息全部删除后才能进行此操作！",
bargainNumber);
return(false);
}
Table <B_BargainInfo> table = dataContxt.GetTable <B_BargainInfo>();
var delRow = from c in table
where c.BargainNumber == bargainNumber
select c;
table.DeleteAllOnSubmit(delRow);
dataContxt.SubmitChanges();
return(GetAllBargainInfo(out returnBargainInfo, out error));
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
private void btnFindOrderForm_Click(object sender, EventArgs e)
{
if (lblBillStatus.Text != OrdinaryInDepotBillStatus.新建单据.ToString())
{
return;
}
FormQueryInfo form = QueryInfoDialog.GetOrderFormInfoDialog(CE_BillTypeEnum.普通入库单);
if (DialogResult.OK == form.ShowDialog())
{
txtOrderFormNumber.Text = form.GetDataItem("订单号").ToString();
txtProvider.Text = form.GetDataItem("供货单位").ToString();
IOrderFormInfoServer orderFormServer = ServerModuleFactory.GetServerModule <IOrderFormInfoServer>();
IBargainInfoServer bargainServer = ServerModuleFactory.GetServerModule <IBargainInfoServer>();
}
}
/// <summary>
/// 获取订单信息对话框
/// </summary>
/// <param name="billType">单据类型</param>
/// <returns>成功则返回获取到的对话框，失败返回null</returns>
static public FormQueryInfo GetOrderFormInfoDialog(CE_BillTypeEnum billType)
{
DepotManagementDataContext dataContext = CommentParameter.DepotDataContext;
IOrderFormInfoServer orderFormInfoServer = ServerModuleFactory.GetServerModule <IOrderFormInfoServer>();
IQueryable <View_B_OrderFormInfo> queryResult;
if (!orderFormInfoServer.GetAllOrderFormInfo(BasicInfo.ListRoles, BasicInfo.LoginID, billType, out queryResult, out m_err))
{
MessageDialog.ShowErrorMessage(m_err);
return(null);
}
System.Data.DataTable dataTable = GlobalObject.GeneralFunction.ConvertToDataTable <View_B_OrderFormInfo>(queryResult);
FormQueryInfo form = new FormQueryInfo(dataTable);
form.HideColumns = new string[] { "供应商联系人", "供应商联系电话", "供应商传真号", "供应商电子邮件", "权限控制用登录名", "录入人员" };
return(form);
}
private void btnBenchCreate_Click(object sender, EventArgs e)
{
try
{
if (cmbBillType.Text.Trim().Length > 0)
{
switch (GlobalObject.GeneralFunction.StringConvertToEnum <CE_InPutBusinessType>(cmbBillType.Text))
{
case CE_InPutBusinessType.生产采购:
case CE_InPutBusinessType.普通采购:
case CE_InPutBusinessType.委外采购:
case CE_InPutBusinessType.样品采购:
IQueryable <View_B_OrderFormInfo> findOrderFormInfo;
IOrderFormInfoServer orderFormServer = ServerModule.ServerModuleFactory.GetServerModule <IOrderFormInfoServer>();
if (!orderFormServer.GetAllOrderFormInfo(BasicInfo.ListRoles, BasicInfo.LoginID, out findOrderFormInfo, out m_strError))
{
MessageDialog.ShowErrorMessage(m_strError);
return;
}
DataTable dataSource = GlobalObject.GeneralFunction.ConvertToDataTable <View_B_OrderFormInfo>(findOrderFormInfo);
FormDataTableCheck frm = new FormDataTableCheck(dataSource);
frm._BlDateTimeControlShow = false;
if (frm.ShowDialog() == DialogResult.OK)
{
List <string> listTemp = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "订单号");
m_listViewDetail = m_serviceRequistion.GetListViewDetail_OrderForm(txtBillNo.Text, listTemp);
RefreshDataGridView(m_listViewDetail);
}
foreach (DataGridViewRow dgvr in customDataGridView1.Rows)
{
((DataGridViewTextBoxShowCell)dgvr.Cells["图号型号"]).m_EndSql =
" and 序号 in ( select GoodsID from B_OrderFormGoods where OrderFormNumber = '"
+ dgvr.Cells["关联业务"].Value.ToString() + "')";
((DataGridViewTextBoxShowCell)dgvr.Cells["批次号"]).ReadOnly = true;
((DataGridViewTextBoxShowCell)dgvr.Cells["供应商"]).ReadOnly = true;
}
break;
default:
break;
}
cmbBillType.Enabled = customDataGridView1.Rows.Count > 0 ? false : true;
}
else
{
MessageDialog.ShowPromptMessage("请选择【业务类型】");
return;
}
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
}
/// <summary>
/// 修改合同信息
/// </summary>
/// <param name="oldBargainNumber">旧合同号</param>
/// <param name="bargainInfo">合同信息</param>
/// <param name="returnBargainInfo">返回查询到的合同信息</param>
/// <param name="error">错误信息, 没有则为null</param>
/// <returns>操作是否成功的标志</returns>
public bool UpdateBargainInfo(string oldBargainNumber, B_BargainInfo bargainInfo,
out IQueryResult returnBargainInfo, out string error)
{
returnBargainInfo = null;
error = null;
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from r in dataContxt.B_BargainInfo
where r.BargainNumber == oldBargainNumber
select r;
if (result.Count() == 0)
{
error = string.Format("找不到合同号为 [{0}] 的信息！", oldBargainNumber);
return(false);
}
B_BargainInfo record = result.Single();
IBargainGoodsServer goodsServer = ServerModuleFactory.GetServerModule <IBargainGoodsServer>();
if (oldBargainNumber != bargainInfo.BargainNumber)
{
IQueryable <View_B_BargainGoods> returnBargainGoods;
if (!goodsServer.GetBargainGoods(oldBargainNumber, out returnBargainGoods, out error))
{
return(false);
}
goodsServer.AutoSubmitToDatabase = false;
foreach (var item in returnBargainGoods)
{
if (!goodsServer.UpdateBargainNumber(dataContxt, item.序号, bargainInfo.BargainNumber, out error))
{
return(false);
}
}
#region 更新订单信息表中的合同编号
IOrderFormInfoServer orderFormServer = ServerModuleFactory.GetServerModule <IOrderFormInfoServer>();
orderFormServer.UpdateBargainNumber(dataContxt, oldBargainNumber, bargainInfo.BargainNumber);
#endregion
dataContxt.B_BargainInfo.DeleteOnSubmit(record);
record = new B_BargainInfo();
}
record.BargainNumber = bargainInfo.BargainNumber;
record.Provider = bargainInfo.Provider;
record.Buyer = bargainInfo.Buyer;
record.Cess = bargainInfo.Cess;
record.Date = bargainInfo.Date;
record.InputPerson = bargainInfo.InputPerson;
record.LaisonMode = bargainInfo.LaisonMode;
record.ProviderLinkman = bargainInfo.ProviderLinkman;
record.IsOverseas = bargainInfo.IsOverseas;
record.IsConsignOut = bargainInfo.IsConsignOut;
record.Remark = bargainInfo.Remark;
record.AuditDate = bargainInfo.AuditDate;
if (oldBargainNumber != bargainInfo.BargainNumber)
{
dataContxt.B_BargainInfo.InsertOnSubmit(record);
}
dataContxt.SubmitChanges();
goodsServer.AutoSubmitToDatabase = true;
return(GetAllBargainInfo(out returnBargainInfo, out error));
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
private void btnAutoGenerate_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
MessageDialog.ShowPromptMessage("请删除此清单中的所有物品后再进行此操作！");
return;
}
IOrderFormGoodsServer orderFormGoodsServer = ServerModuleFactory.GetServerModule <IOrderFormGoodsServer>();
IQueryable <View_B_OrderFormGoods> goodsGroup = null;
if (!orderFormGoodsServer.GetOrderFormGoods(
BasicInfo.ListRoles, BasicInfo.LoginID, m_billInfo.OrderBill_ID, out goodsGroup, out m_error))
{
MessageDialog.ShowErrorMessage(m_error);
return;
}
S_OrdinaryInDepotBill lnqBill = m_serverBill.GetBill(m_billNo);
IOrderFormInfoServer serviceOrderForm = ServerModuleFactory.GetServerModule <IOrderFormInfoServer>();
View_B_OrderFormInfo orderInfo = serviceOrderForm.GetOrderFormInfo(m_billInfo.OrderBill_ID);
foreach (var item in goodsGroup)
{
if (item.订货数量 == 0)
{
continue;
}
S_OrdinaryInDepotGoodsBill goods = new S_OrdinaryInDepotGoodsBill();
View_F_GoodsPlanCost planCost = GetBasicGoodsInfo(item.图号型号, item.物品名称, item.规格, 0);
if (planCost == null)
{
return;
}
goods.GoodsID = planCost.序号;
goods.Bill_ID = m_billNo;
goods.ProviderBatchNo = "";
if (m_serverGoodsShelfLife.IsShelfLife(planCost.序号))
{
goods.BatchNo = m_goodsServer.GetNewBatchNo();
}
else
{
goods.BatchNo = "";
}
goods.Amount = item.订货数量;
IBargainGoodsServer serviceBargainGoods = ServerModuleFactory.GetServerModule <IBargainGoodsServer>();
goods.UnitPrice = serviceBargainGoods.GetGoodsUnitPrice(orderInfo.订单号, goods.GoodsID, orderInfo.供货单位);
goods.Price = decimal.Round(goods.UnitPrice * item.订货数量, (int)2);
goods.AmountInWords = CalculateClass.GetTotalPrice(goods.Price);
goods.Remark = txtRemark.Text;
if (!m_goodsServer.AddGoods(m_billNo, goods, out m_queryResult, out m_error))
{
MessageDialog.ShowErrorMessage(m_error);
return;
}
}
btnRefresh_Click(sender, e);
}