/// <summary>
/// 审核订单
/// </summary>
/// <param name="auditingPersonnel">审核人工号</param>
/// <param name="orderFormNumber">审核订单号</param>
/// <param name="error">错误信息, 没有则为null</param>
/// <returns>操作是否成功的标志</returns>
public bool Auditing(string auditingPersonnel, string orderFormNumber, out string error)
{
error = null;
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
try
{
var varData = from a in dataContxt.B_OrderFormInfo
where a.OrderFormNumber == orderFormNumber
select a;
if (varData.Count() == 0)
{
error = "无记录";
return(false);
}
B_OrderFormInfo lnqOrderForm = varData.Single();
lnqOrderForm.DepartmentDirector = auditingPersonnel;
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
if (m_orderFormServer.FindInDepotOrderGoodsCount(txtOrderFormNumber.Text.Trim()))
{
MessageDialog.ShowPromptMessage("请先删除该订单关联的入库单再做此操作！");
return;
}
if (!CheckOrderFormDataItem())
{
return;
}
if (dataGridView1.SelectedRows.Count == 0)
{
MessageDialog.ShowPromptMessage("请选择需要修改的数据行!");
return;
}
B_OrderFormInfo info = new B_OrderFormInfo();
info.TypeID = m_dicOrderFormType[cmbOrderFormType.Text];
info.OrderFormNumber = txtOrderFormNumber.Text;
info.BargainNumber = txtBargainNumber.Text;
info.Buyer = txtBuyer.Tag.ToString();
info.CreateDate = dateTimeOrder.Value;
info.InputPerson = BasicInfo.LoginName;
info.Provider = txtProvider.Text;
info.ProviderPhone = txtProviderPhone.Text;
info.ProviderLinkman = txtProviderLinkman.Text;
info.ProviderFax = txtProviderFax.Text;
info.ProviderEmail = txtProviderEMail.Text;
info.Remark = txtRemark.Text;
if (!m_orderFormServer.UpdateOrderFormInfo(BasicInfo.ListRoles, BasicInfo.LoginID,
txtOrderFormNumber.Text, info, out m_findOrderFormInfo, out m_err))
{
MessageDialog.ShowErrorMessage(m_err);
return;
}
RefreshOrderFormDataGridView();
PositioningRecord(info.OrderFormNumber);
RefreshOrderFormControl();
txtOrderFormNumber.ReadOnly = true;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
if (!CheckOrderFormDataItem())
{
return;
}
txtOrderFormNumber.Text = m_orderFormServer.GetOrderNo(txtProvider.Text);
txtBargainNumber.Text = "价格清单";
B_OrderFormInfo info = new B_OrderFormInfo();
info.TypeID = m_dicOrderFormType[cmbOrderFormType.Text];
info.OrderFormNumber = txtOrderFormNumber.Text;
info.BargainNumber = txtBargainNumber.Text;
info.Buyer = txtBuyer.Tag.ToString();
info.CreateDate = dateTimeOrder.Value;
info.InputPerson = BasicInfo.LoginName;
info.Provider = txtProvider.Text;
info.ProviderPhone = txtProviderPhone.Text;
info.ProviderLinkman = txtProviderLinkman.Text;
info.ProviderFax = txtProviderFax.Text;
info.ProviderEmail = txtProviderEMail.Text;
info.Remark = txtRemark.Text;
if (!m_orderFormServer.AddOrderFormInfo(BasicInfo.ListRoles, BasicInfo.LoginID, info, out m_findOrderFormInfo, out m_err))
{
MessageDialog.ShowErrorMessage(m_err);
return;
}
else
{
MessageDialog.ShowPromptMessage("已添加订单，【订单编号】：" + info.OrderFormNumber);
}
ClearControl();
RefreshOrderFormDataGridView();
PositioningRecord(info.OrderFormNumber);
RefreshOrderFormControl();
txtOrderFormNumber.ReadOnly = true;
}
/// <summary>
/// 添加订单信息
/// </summary>
/// <param name="listRole">角色列表</param>
/// <param name="loginName">登录名</param>
/// <param name="orderFormInfo">订单信息</param>
/// <param name="returnOrderFormInfo">返回查询到的订单信息</param>
/// <param name="error">错误信息, 没有则为null</param>
/// <returns>操作是否成功的标志</returns>
public bool AddOrderFormInfo(List <string> listRole, string loginName, B_OrderFormInfo orderFormInfo,
out IQueryable <View_B_OrderFormInfo> returnOrderFormInfo, out string error)
{
returnOrderFormInfo = null;
error = null;
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
try
{
dataContxt.B_OrderFormInfo.InsertOnSubmit(orderFormInfo);
dataContxt.SubmitChanges();
return(GetAllOrderFormInfo(listRole, loginName, out returnOrderFormInfo, out error));
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
/// <summary>
/// 插入WINFORM订单
/// </summary>
/// <param name="context">数据上下文</param>
/// <param name="yearAndMonth">操作的年月字符串</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>插入成功返回True,插入失败返回False</returns>
bool InsertWinFormOrderForm(DepotManagementDataContext context, string yearAndMonth, out string error)
{
BargainInfoServer serverBargainInfo = new BargainInfoServer();
try
{
error = null;
//插入订单Bill
string strSql = "select distinct 订单号 + '-' + convert(varchar(50),ID) as 订单号 ," +
" 合同号 from (select 物品ID,供应商,订单号,到货数,到货日期,合同号, " +
" Row_Number()Over(partition by 物品ID,供应商 order by 到货日期) as ID " +
" from View_B_WebForOrderFormList as a inner join View_B_WebForAffrimTime as b " +
" on a.序号 = b.明细ID where 单据号 = '" + yearAndMonth + "') as a";
DataTable dtBill = GlobalObject.DatabaseServer.QueryInfo(strSql);
for (int i = 0; i < dtBill.Rows.Count; i++)
{
DataRow drBargainInfo = serverBargainInfo.GetBargainInfoDataRow(dtBill.Rows[i]["合同号"].ToString());
B_OrderFormInfo lnqInfo = new B_OrderFormInfo();
lnqInfo.BargainNumber = drBargainInfo["BargainNumber"].ToString();
lnqInfo.Buyer = drBargainInfo["Buyer"].ToString();
lnqInfo.CreateDate = ServerTime.Time;
lnqInfo.InputPerson = drBargainInfo["InputPerson"].ToString();
lnqInfo.OrderFormNumber = dtBill.Rows[i]["订单号"].ToString();
lnqInfo.Provider = drBargainInfo["Provider"].ToString();
lnqInfo.ProviderLinkman = drBargainInfo["ProviderLinkman"].ToString();
lnqInfo.ProviderPhone = drBargainInfo["LaisonMode"].ToString();
lnqInfo.ProviderFax = drBargainInfo["LaisonMode"].ToString();
lnqInfo.ProviderEmail = "";
lnqInfo.Remark = drBargainInfo["Remark"].ToString();
lnqInfo.TypeID = 2;
context.B_OrderFormInfo.InsertOnSubmit(lnqInfo);
}
//插入订单List
strSql = "select 图号型号,物品名称,规格,到货数," +
" 订单号 + '-' + convert(varchar(50),ID) as 订单号 ," +
" convert(varchar(10), 到货日期,120) + ' 23:59:59' as 到货日期 " +
" from (select 图号型号,物品名称,规格,订单号,到货数,到货日期,物品ID " +
" Row_Number()Over(partition by 物品ID,供应商 order by 到货日期) as ID " +
" from View_B_WebForOrderFormList as a " +
" inner join View_B_WebForAffrimTime as b " +
" on a.序号 = b.明细ID where 单据号 = '" + yearAndMonth + "') as a ";
DataTable dtList = GlobalObject.DatabaseServer.QueryInfo(strSql);
for (int i = 0; i < dtList.Rows.Count; i++)
{
B_OrderFormGoods lnqGoods = new B_OrderFormGoods();
lnqGoods.Amount = Convert.ToDecimal(dtList.Rows[i]["到货数"]);
lnqGoods.ArrivalDate = Convert.ToDateTime(dtList.Rows[i]["到货日期"]);
lnqGoods.CreateDate = ServerTime.Time;
lnqGoods.OrderFormNumber = dtList.Rows[i]["订单号"].ToString();
lnqGoods.Remark = "";
lnqGoods.GoodsID = (int)dtList.Rows[i]["物品ID"];
context.B_OrderFormGoods.InsertOnSubmit(lnqGoods);
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改订单信息
/// </summary>
/// <param name="listRole">角色列表</param>
/// <param name="loginName">登录名</param>
/// <param name="oldOrderFormNumber">旧订单号</param>
/// <param name="orderFormInfo">订单信息</param>
/// <param name="returnOrderFormInfo">返回查询到的订单信息</param>
/// <param name="error">错误信息, 没有则为null</param>
/// <returns>操作是否成功的标志</returns>
public bool UpdateOrderFormInfo(List <string> listRole, string loginName, string oldOrderFormNumber,
B_OrderFormInfo orderFormInfo, out IQueryable <View_B_OrderFormInfo> returnOrderFormInfo, out string error)
{
returnOrderFormInfo = null;
error = null;
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
try
{
var result = from r in dataContxt.B_OrderFormInfo where r.OrderFormNumber == oldOrderFormNumber select r;
if (result.Count() == 0)
{
error = string.Format("找不到订单号为 [{0}] 的信息！", oldOrderFormNumber);
return(false);
}
B_OrderFormInfo record = result.Single();
IOrderFormGoodsServer goodsServer = ServerModuleFactory.GetServerModule <IOrderFormGoodsServer>();
if (oldOrderFormNumber != orderFormInfo.OrderFormNumber)
{
IQueryable <View_B_OrderFormGoods> returnOrderFormGoods;
if (!goodsServer.GetOrderFormGoods(listRole, loginName, oldOrderFormNumber,
out returnOrderFormGoods, out error))
{
return(false);
}
goodsServer.AutoSubmitToDatabase = false;
foreach (var item in returnOrderFormGoods)
{
if (!goodsServer.UpdateOrderFormNumber(dataContxt, listRole, loginName, item.序号,
orderFormInfo.OrderFormNumber, out error))
{
return(false);
}
}
dataContxt.B_OrderFormInfo.DeleteOnSubmit(record);
record = new B_OrderFormInfo();
}
record.OrderFormNumber = orderFormInfo.OrderFormNumber;
record.Provider = orderFormInfo.Provider;
record.Buyer = orderFormInfo.Buyer;
record.BargainNumber = orderFormInfo.BargainNumber;
record.TypeID = orderFormInfo.TypeID;
record.InputPerson = orderFormInfo.InputPerson;
record.ProviderLinkman = orderFormInfo.ProviderLinkman;
record.ProviderEmail = orderFormInfo.ProviderEmail;
record.ProviderPhone = orderFormInfo.ProviderPhone;
record.ProviderFax = orderFormInfo.ProviderFax;
record.Remark = orderFormInfo.Remark;
record.TypeID = orderFormInfo.TypeID;
record.CreateDate = orderFormInfo.CreateDate;
if (oldOrderFormNumber != orderFormInfo.OrderFormNumber)
{
dataContxt.B_OrderFormInfo.InsertOnSubmit(record);
}
dataContxt.SubmitChanges();
goodsServer.AutoSubmitToDatabase = true;
return(GetAllOrderFormInfo(listRole, loginName, out returnOrderFormInfo, out error));
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
