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