/// <summary> /// 获取过滤条件 /// </summary> /// <returns></returns> private string GetFilter() { StringBuilder sFilter = new StringBuilder(); sFilter.Append(" 1=1 "); string sOrder_State = this.cmbItemState.SelectedValue.ToString(); string dtStar = dtStartDate.Checked ? this.dtStartDate.Value.ToLongDateString(): ""; string dtEnd = dtEndDate.Checked? this.dtEndDate.Value.AddDays(1).ToLongDateString():""; string sType = this.cmbType.SelectedValue.ToString(); string sTypeValue = StringUtils.repalceSepStr(this.txtName.Text.ToString()); bool isfactory = this.CurrentUserIsFactory; string AreaList = this.CurrentUserAreaList; string UserId = this.CurrentUserId; if (!string.IsNullOrEmpty(sOrder_State)) { if (sOrder_State.Equals("-1")) { sFilter.Append("and order_state <> '3' "); } else { sFilter.Append("and order_state = '").Append(sOrder_State).Append("' "); } } if (!string.IsNullOrEmpty(sTypeValue)) { //买方企业 if (sType.Equals("1")) { sFilter.AppendFormat(" and (BAK_BUYER_NAME like '%{0}%' or BAK_BUYER_EASY like '%{0}%' or BAK_BUYER_FAST like '%{0}%' or BAK_BUYER_WUBI LIKE '%{0}%')", sTypeValue.ToUpper()); } else { sFilter.AppendFormat(" AND ORDER_CODE LIKE '%{0}%'", sTypeValue); } } if (!string.IsNullOrEmpty(dtStar)) { sFilter.AppendFormat(" AND CREATE_DATE >= '{0}'", dtStar); } if (!string.IsNullOrEmpty(dtEnd)) { sFilter.AppendFormat(" AND CREATE_DATE < '{0}'", dtEnd); } if (!isfactory) { sFilter.AppendFormat(" and area_id in (").Append(AreaList).Append(")"); } else { if (SalerOrderBLL.GetInstance().isfactory(UserId)) { sFilter.AppendFormat(" and area_id in (").Append(AreaList).Append(")"); } } return(sFilter.ToString()); }
/// <summary> /// 取得订单列表 /// </summary> public void GetSalerOrderList() { if (!offlineFlag) { int rows; DataTable dt = ProxyFactory.SalerOrderProxy.getSalerOrderList(getSearchKey(), out rows); //绑定数据源 this.orderListBindingSource.DataSource = dt; pageNavigator1.ItemCount = rows; } else { DataTable dt = SalerOrderBLL.GetInstance().getSalerOrderList(base.CurrentUserOrgId); dtList = dt; string sFilter = GetFilter(); dt.DefaultView.RowFilter = sFilter; InitFromCacheByData(dt); //绑定数据源 this.orderListBindingSource.DataSource = base.gridDataView; pageNavigator1.ItemCount = base.cachedDataView.Count; } this.NoVisibleBtn(); this.dgvSalerOrderList.Select(); }
//"导入订单"判断业务流程("进销存"企业对接功能),shangfu 2007-8-28 private void RetOrderItem(out int count) { count = 0; //DataColumn dc = new DataColumn("state"); //dc.DataType = System.Type.GetType("System.String"); //dc.DefaultValue = "状态"; //this.dtImp.Columns.Add(dc); foreach (DataGridViewRow dgvr in dgvErpSend.Rows) { string orderItemId = dgvr.Cells["ordItemId"].Value.ToString(); bool flag = SalerOrderBLL.GetInstance().GetOrderItem(orderItemId); if (flag) { dgvr.Cells["type"].Value = "0"; dgvr.Cells["state"].Value = "匹配成功"; dgvr.Cells["EmedProductCode"].Value = ""; count++; } else { dgvr.Cells["type"].Value = "1"; dgvr.Cells["state"].Value = "匹配失败"; dgvr.Cells["EmedProductCode"].Value = ""; //DataRow r = this.dtImp.NewRow(); ////r["state"] = r["state"].ToString(); //r["BUYER_CODE"] = r["BUYER_CODE"].ToString(); //r["BUYER_NAME"] = r["BUYER_NAME"].ToString(); //r["BUYER_EASY"] = r["BUYER_EASY"].ToString(); //r["MEDICAL_CODE"] = r["MEDICAL_CODE"].ToString(); //r["MEDICAL_NAME"] = r["MEDICAL_NAME"].ToString(); //r["PRODUCT_CODE"] = r["PRODUCT_CODE"].ToString(); //r["PRODUCT_NAME"] = r["PRODUCT_NAME"].ToString(); //r["MEDICAL_MODE_CODE"] = r["MEDICAL_MODE_CODE"].ToString(); //r["MEDICAL_MODE"] = r["MEDICAL_MODE"].ToString(); //r["MEDICAL_SPEC_CODE"] = r["MEDICAL_SPEC_CODE"].ToString(); //r["MEDICAL_SPEC"] = r["MEDICAL_SPEC"].ToString(); //r["SPEC_UNIT_CODE"] = r["SPEC_UNIT_CODE"].ToString(); //r["SPEC_UNIT"] = r["SPEC_UNIT"].ToString(); //r["FACTORY_CODE"] = r["FACTORY_CODE"].ToString(); //r["FACTORY_NAME"] = r["FACTORY_NAME"].ToString(); //r["LOT_NO"] = r["LOT_NO"].ToString(); //r["RECEIVE_QTY"] = r["RECEIVE_QTY"]; //r["INVOICE_NO"] = r["INVOICE_NO"]; //r["INVOICE_DATE"] = r["INVOICE_DATE"]; //r["INVOICE_TOTAL"] = r["INVOICE_TOTAL"]; //r["INVOICE_EXPIRE_DATE"] = r["INVOICE_EXPIRE_DATE"]; //r["INVOICE_TRADE_PRICE"] = r["INVOICE_TRADE_PRICE"]; //r["INVOICE_RETAIL_PRICE"] = r["INVOICE_RETAIL_PRICE"]; //r["READY_REMARK"] = r["READY_REMARK"].ToString(); //r["ORD_ITEM_ID"] = r["ORD_ITEM_ID"].ToString(); //r["STAND_RATE"] = r["STAND_RATE"]; //this.dtImp.Rows.Add(r); } } }
/// <summary> /// 备货 /// </summary> /// <param name="result"></param> /// <param name="type"></param> /// <param name="remark"></param> /// <param name="ui"></param> /// <returns></returns> public bool ReceiveOrder(IList result, string remark, Emedchina.TradeAssistant.Model.User.UserInfo ui) { try { return(SalerOrderBLL.GetInstance().ReceiveOrder(result, remark, ui)); } catch (Exception x) { throw x; return(false); } }
/// <summary> /// 缺货 /// </summary> /// <param name="result"></param> /// <param name="type"></param> /// <param name="ui"></param> /// <returns></returns> public bool OrderLack(IList result, Emedchina.TradeAssistant.Model.User.UserInfo ui) { try { return(SalerOrderBLL.GetInstance().OrderLack(result, ui)); } catch (Exception x) { throw x; return(false); } }
/// <summary> /// 撤消发货 /// </summary> /// <param name="result"></param> /// <param name="type"></param> /// <param name="ui"></param> /// <returns></returns> public bool DeleteOrderReceive(IList result) { try { return(SalerOrderBLL.GetInstance().DeleteOrderReceive(result)); } catch (Exception x) { throw x; return(false); } }
/// <summary> /// 判断是否有未匹配的数据 /// </summary> /// <param name="sOrderID"></param> /// <param name="sOrgID"></param> /// <returns></returns> private bool IfHasNotMapData(string sOrderID, string sOrgID) { bool bHasNotMap = false; DataTable dtCrop = new DataTable(); DataTable dtProd = new DataTable(); dtCrop = SalerOrderBLL.GetInstance().GetNotMapCorp(sOrderID, sOrgID); dtProd = SalerOrderBLL.GetInstance().GetNotMapProd(sOrderID, sOrgID); if (dtCrop.Rows.Count > 0 || dtProd.Rows.Count > 0) { bHasNotMap = true; } return(bHasNotMap); }
private void btnExpProduct_Click(object sender, EventArgs e) { //DataTable dt = ProxyFactory.SalerOrderProxy.GetProductInfo(base.CurrentUserRegOrgId); DataTable dt = SalerOrderBLL.GetInstance().GetProductInfo(base.CurrentUserRegOrgId); if (dt.Rows.Count > 0) { string expFilePath = SelectExporFile("导出产品信息"); if (FileOperation.ExportExcelFile(dt, expFilePath)) { //thread.Abort(); MessageBox.Show("导出成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } else { MessageBox.Show("没有数据!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
/// <summary> /// 取得订单明细列表数据 /// </summary> public IList GetSalerOrderItemList(string orderId) { return(SalerOrderBLL.GetInstance().GetSalerOrderItemList(orderId)); }
/// <summary> /// Gets the SalerOrderModel /// </summary> /// <param name="name">The name.</param> /// <returns></returns> //public SalerOrderModel GetOrderById(string orderId, string userId) //{ // //return SalerOrderBLL.GetInstance().GetOrderById(orderId, userId); //} /// <summary> /// 取得订单明细列表数据 /// </summary> public IList GetSalerOrderItemList(string orderId, string userName, string userId, bool flag) { return(SalerOrderBLL.GetInstance().GetSalerOrderItemList(orderId, userName, userId, flag)); }
/// <summary> /// 取得订单列表数据 /// </summary> public DataTable getSalerOrderList(SalerOrderListModel model, out int rows) { return(SalerOrderBLL.GetInstance().getSalerOrderList(model, out rows)); }
/// <summary> /// 判断同一个企业的备货发票是否有重复 有重复返回true /// </summary> /// <param name="resultList"></param> /// <returns></returns> public bool IsInvoiceExists(IList resultList) { return(SalerOrderBLL.GetInstance().IsInvoiceExists(resultList)); }
/// <summary> /// 取得订单信息 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public SalerOrderModel GetOrderTitle(string orderId) { return(SalerOrderBLL.GetInstance().GetOrderTitle(orderId)); }
/// <summary> /// 查询待确定和已确定的送货列表 /// </summary> /// <param name="input"></param> /// <param name="pageParam"></param> /// <param name="rows"></param> /// <returns></returns> public IList selectOrderPrepareItemListJP(InputInfoModel input) { return(SalerOrderBLL.GetInstance().selectOrderPrepareItemListJP(input)); }