public ViewBuyerOrder(OrderModel buyerOrder) { InitializeComponent(); input = new BuyerOrderModel(); input.UserId = base.CurrentUserId; input.UserName = base.CurrentUserName; input.SalerId = base.CurrentUserRegOrgId; input.AreaId = base.CurrentUserSingleRegionId; input.Flag = "1"; ClearTxt(); this.lcOrderCode.Text = buyerOrder.OrderCode; this.lcCreater.Text = buyerOrder.CreateUserName.Trim(); this.lcCreateTime.Text = buyerOrder.CreateDate; this.lcSaler.Text = buyerOrder.SalerName; this.lcPurchaseState.Text = buyerOrder.OrderState; this.lcModifyer.Text = buyerOrder.ModifyUserName; this.lcModifyTime.Text = buyerOrder.ModifyDate; this.lcSender.Text = buyerOrder.SenderName; this.lcTotal.Text = buyerOrder.Total_sum + "(元)";; this.lcSalerPeople.Text = buyerOrder.SalerApproverName; this.lcAffirmTiem.Text = buyerOrder.SalerApproveDate; this.lcBuyerRemark.Text = buyerOrder.BuyerRemark; this.lcTotalFinish.Text = buyerOrder.Over_sum + "(元)"; this.lcSalerRemark.Text = buyerOrder.SalerRemark; }
/// <summary> /// 取得按订单到货列表数据 /// </summary> public DataSet GetBuyerOrderList(BuyerOrderModel input, out int rows) { DataSet ds = new DataSet(); try { StringBuilder sql = new StringBuilder(); sql.Append("select o.id as id ,o.state,o.sender_id ,PURCHASE_CODE,o.sender_name,o.sender_name_abbr,o.create_date,(case when o.Total_sum is null then '-' else o.Total_sum end) As Total_sum,(case when o.over_sum is null then '-' else o.over_sum end) As over_sum,"); sql.Append(" (case when o.Create_User_name ='' or o.Create_User_name is null then '-' else o.Create_User_name end) As Create_User_name ,o.order_code,"); sql.Append(" (case o.STATE when '1' then '未阅读' when '2' then '已阅读' when '3' then '确认' when '4' then '处理中' when '5' then '完成' when '6' then '作废' end) As Order_State, "); sql.Append(" o.type As orderType, "); sql.Append(" (case o.type when '1' then '普通订单' when '2' then '发货流程' when '3' then '确认单(备货)' end) As type, "); sql.Append(" (case o.QUICKSEND_LEVEL when '1' then '普通' when '2' then '部分紧急' when '3' then '紧急' end) As QUICKSEND_LEVEL ,SALER_DESCRIPTIONS,BUYER_DESCRIPTIONS,SALER_APPROVER_NAME,SALER_APPROVER_DATE,MODIFY_USER_NAME,MODIFY_DATE"); sql.Append(" from HC_ORD_ORDER o "); List <DbParameter> parameters = new List <DbParameter>(); sql.Append(" where 1 = 1 "); input.Rows = base.GetRowCount(sql.ToString(), parameters.ToArray()); rows = input.Rows; DataTable tb = base.DbFacade.SQLExecuteDataTable(sql.ToString(), parameters.ToArray()); ds.Tables.Add(tb); } catch (Exception e) { throw e; } return(ds); }
private void BuyerOrderList_Load(object sender, EventArgs e) { input = new BuyerOrderModel(); btnSearch_Click(null, null); deStartDate.EditValue = DateTime.Now.AddMonths(-1); deEndDate.EditValue = DateTime.Now; this.cmbOrderStatus.Text = "全部"; this.cmbType.Text = "全部"; //this.cmbSearchField.Text = "经销企业"; //base.SetPoint(gridView3); }
/// <summary> /// 取得发票号数据 /// </summary> public List <string> GetInvoiceNoListByOrderId(BuyerOrderModel input) { List <string> invoiceNo = new List <string>(); DataTable dt = dao.SearchInvoiceNoByOrderId(input); for (int i = 0; i < dt.Rows.Count; i++) { invoiceNo.Add(dt.Rows[i]["invoice_no"].ToString()); } return(invoiceNo); }
private void simpleButton8_Click(object sender, EventArgs e) { if (input == null) { input = new BuyerOrderModel(); input.UserId = base.CurrentUserId; input.UserName = base.CurrentUserName; input.SalerId = base.CurrentUserRegOrgId; input.AreaId = base.CurrentUserSingleRegionId; input.OrderId = orderModel.Id; input.Remark = this.rtbRemarkA.Text; } //离线 if (BuyerOrderOfflineBLL.GetInstance().SaveRemark(input)) { XtraMessageBox.Show("保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } ClientSession.GetInstance()["remark"] = input.Remark; }
public DoWithOrder(OrderModel buyerOrder, BuyerOrderModel input) { InitializeComponent(); input = new BuyerOrderModel(); input.UserId = base.CurrentUserId; input.UserName = base.CurrentUserName; input.SalerId = base.CurrentUserRegOrgId; input.AreaId = base.CurrentUserSingleRegionId; input.HighId = ClientSession.GetInstance().CurrentUser.HighId; input.Flag = "1"; ClearTxt(); orderModel = buyerOrder; input = input; input.OrderId = orderModel.Id; searchNoArrived(); if (!buyerOrder.OrderState.Equals("处理中") && !buyerOrder.OrderState.Equals("确认")) { this.xtraTabControl1.SelectedTabPage = this.xtraTabPage3; this.xtraTabControl1.TabPages.Remove(this.xtraTabPage2); this.xtraTabControl1.TabPages.Remove(this.xtraTabPage1); } }
/// <summary> /// 取得发票号数据 /// </summary> public List <string> GetInvoiceNoList(BuyerOrderModel input) { return(dao.GetInvoiceNoList(input)); }
//已到货列表的检索 public DataSet getArrivedList(UserInfo ui, string type, string id, BuyerOrderModel input) { return(dao.getArrivedList(ui, type, id, input)); }
/// <summary> /// 保存备注 /// </summary> public bool SaveRemark(BuyerOrderModel input) { return(dao.SaveRemark(input)); }
/// <summary> /// 取订单状态 /// </summary> public string GetOrderState(BuyerOrderModel input) { return(dao.GetOrderState(input)); }
/// <summary> /// 到货确认 /// </summary> public void ArrivedConfirm(BuyerOrderModel input) { dao.ArrivedConfirm(input); }
/// <summary> /// 取到货金额 /// </summary> public String GetReceiveTotalByOrder(BuyerOrderModel input) { return(dao.GetReceiveTotalByOrder(input)); }
//已到货列表的检索 public DataSet getArrivedList(UserInfo ui, string type, string id, BuyerOrderModel input) { StringBuilder sql = new StringBuilder(); //sql.Append(" SELECT "); //sql.Append(" H.MEDICAL_NAME, "); //--通用名 //sql.Append(" H.TRADE_NAME, "); //--商品名 //sql.Append(" H.MEDICAL_WUBI, "); //--商品名 //sql.Append(" H.MEDICAL_PINYIN, "); //--商品名 //sql.Append(" H.SPELL_ABBR, "); //--商品名 //sql.Append(" H.NAME_WB, "); //--商品名 //sql.Append(" iif(h.Spec is null,'-',h.spec) & '×' & iif(h.Stand_Rate Is Null, '-',h.Stand_Rate) & iif(h.Use_Unit Is Null, '',h.Use_Unit) & '/' & iif(h.Spec_Unit Is Null, '',h.Spec_Unit) & Switch(h.Wrap_Name Is Null, '', h.Wrap_Name='空', '',True,'(' & h.Wrap_Name & ')') As Ggbz,");//规格包装 //sql.Append(" H.DOSEAGE_FORM, "); //sql.Append(" Switch(h.Province_Max_Price Is Null,'-',True,Trim(Format(h.Province_Max_Price, 'Standard'))) As Province_Max_Price,"); //sql.Append(" Switch(h.Province_Insurance_Flag='0','非国家基本医疗保险产品',h.Province_Insurance_Flag='1', '甲类', h.Province_Insurance_Flag='2', '乙类', h.Province_Insurance_Flag='3', '民族药') As Province_Insurance_Flag,"); //sql.Append(" H.DEALER_FULLNAME, "); //--经销企业 //sql.Append(" L.NAME, "); //--合同名称 //sql.Append(" H.LAST_ORDER_DATE, "); //--最后制单日期 //sql.Append(" CInt(H.LAST_ORDER_QTY) as LAST_ORDER_QTY, "); //--最后制单数量 //sql.Append(" Switch(Oi.Con_Type='1', '招标', Oi.Con_Type='2', '竞价', Oi.Con_Type='3', '询价', Oi.Con_Type='4', '备案', Oi.Con_Type='7', '浏览', Oi.Con_Type='9', '临时', Oi.Con_Type='c','GPO直销', Oi.Con_Type='d', 'GPO自主合同') as Con_Type,");//--合同类型 //sql.Append(" format(OI.UNIT_PRICE,'Standard') As UNIT_PRICE, ");//单价 //sql.Append(" CInt(OI.REQUEST_QTY) as REQUEST_QTY, "); //--定购量 //sql.Append(" '完成' AS STATUS, "); //--状态 //sql.Append(" iif(REC.LOT_NO is null,'-',REC.LOT_NO) AS LOT_NO, "); //--批号 //sql.Append(" CInt(REC.RECEIVE_QTY) as RECEIVE_QTY, "); //--确认到货量 //sql.Append(" OI.REMARK, "); //--备注 //sql.Append(" OI.BUYER_DESC, "); //--买方备注 //sql.Append(" REC.RECEIVE_REMARK, "); //--到货接收备注 //sql.Append(" REC.INVOICE_NO, "); //--发票号 //sql.Append(" REC.AMOUNT, "); //--发票金额 //sql.Append(" format(REC.TRADE_PRICE,'Standard') As TRADE_PRICE,");//--批发价 //sql.Append(" format(REC.RETAIL_PRICE,'Standard') As RETAIL_PRICE,");//--零售价 //sql.Append(" REC.DISCOUNT, "); //--扣率 //sql.Append(" format(REC.INVOICE_DATE,'yyyy-mm-dd') As INVOICE_DATE,");//--开票日期 //sql.Append(" format(REC.INVOICE_EXPIRE_DATE,'yyyy-mm-dd') As INVOICE_EXPIRE_DATE ");//--有效期 //sql.Append(" FROM GPO_ORDER_RECEIVE REC, GPO_ORDER_ITEM OI, GPO_HIT_COMM H ,CONT_LIST L "); //sql.Append(" WHERE REC.ORDER_ITEM_ID = OI.RECORD_ID "); //sql.Append(" AND OI.HIT_COMM_ID = H.RECORD_ID "); //sql.Append(" AND H.CONTRACT_ID = L.ID "); //sql.Append(" AND REC.ORDER_ID = :ID"); sql.Append(" SELECT h.id as Product_Id,h.MANU_NAME,h.MANU_NAME_ABBR, h.COMMERCE_NAME as "); sql.Append(" Trade_Name,h.product_name ,h.CODE, h.common_name,h.ABBR_PY,h.ABBR_WB,"); sql.Append(" OI.model,(case when OI.Spec is null then '-' else OI.spec end) as Spec ,"); sql.Append(" oi.Id, oi.Order_Id, "); sql.Append(" (case when oi.trade_Price Is Null then '-' else oi.trade_Price end) As "); sql.Append(" trade_Price,oi.sender_Name,oi.sender_Name_Abbr,"); sql.Append(" (case oi.STATE when '1' then '发送' when '2' then '已阅读' when '3' then '作废' when '4' then '已确认' when '5' then '完成' end) As status, "); sql.Append(" (case when oi.RETAIL_PRICE Is Null then '-' else oi.RETAIL_PRICE end) "); sql.Append(" As RETAIL_PRICE,oi.SUM AS total,"); sql.Append(" cast(oi.AMOUNT as int) As Request_Qty, oi.SALER_DESCRIPTIONS as Saler_Desc,"); sql.Append(" oi.BUYER_DESCRIPTIONS as Buyer_Desc, '已送货' As Status,"); sql.Append(" cast(oi.OVER_AMOUNT as int) as OVER_AMOUNT,"); sql.Append(" cast(oi.OVER_SUM as int) as OVER_SUM,(case when oi.Send_measure is null then '-' else oi.Send_measure end ) as Send_measure,"); sql.Append(" (case when REC.INSTORE_BATCH_NO is null then '-' else REC.INSTORE_BATCH_NO end) "); sql.Append(" AS LOT_NO, "); sql.Append(" cast(REC.FACT_AMOUNT as int) as RECEIVE_QTY, "); sql.Append(" REC.DESCRIPTIONS, "); sql.Append(" REC.INVOICE_ID, "); sql.Append(" REC.PRICE As TRADE_PRICE"); sql.Append(" FROM HC_ORD_ORDER_RECEIVE REC, HC_ORD_ORDER_ITEM OI, HC_ORD_PRODUCT H "); sql.Append(" WHERE REC.ORDER_ITEM_ID = OI.ID AND OI.PROJECT_PROD_ID = H.ID "); sql.Append(" AND REC.ORDER_ID = @ID and OI.state <> '3'"); List <DbParameter> parameters = new List <DbParameter>(); DbParameter idPara = DbFacade.CreateParameter(); idPara.ParameterName = "ID"; idPara.DbType = DbType.String; idPara.Value = id; parameters.Add(idPara); DataSet ds = new DataSet(); DataTable newsTable = DbFacade.SQLExecuteDataTable(sql.ToString(), "ARRIVESALER", idPara); ds.Tables.Add(newsTable); return(ds); }
/// <summary> /// 取得按企业到货列表数据 /// </summary> public DataSet GetBuyerOrderByOrgList(BuyerOrderModel input, out int rows) { DataSet ds = new DataSet(); StringBuilder sql = new StringBuilder(); try { //sql.Append("select distinct o.saler_id,"); //sql.Append(" o.saler_name as saler_name,"); //sql.Append(" o.saler_easy as saler_easy,"); //sql.Append(" count(1) as order_num, "); //sql.Append(" Trim(Format(Sum(o.Request_Total), 'Standard')) As request_total, "); //sql.Append(" Sum(o.Request_Total) As request_total_num "); //sql.Append(" from gpo_order o"); sql.Append("Select a.*,b.Org_Name As Saler_Name, b.Org_Easy As Saler_Easy"); sql.Append(" From"); sql.Append(" ("); sql.Append(" Select Distinct o.Saler_Id, Count(1) As Order_Num"); sql.Append(" ,Trim(Format(Sum(o.Request_Total), 'Standard')) As Request_Total,"); sql.Append(" Sum(o.Request_Total) As Request_Total_Num"); sql.Append(" From Gpo_Order o"); List <DbParameter> parameters = new List <DbParameter>(); sql.Append(" where 1=1 "); //sql.Append(" and o.order_state = '2' "); sql.Append(" and o.area_id = :areaId"); DbParameter areaIdPara = this.DbFacade.CreateParameter(); areaIdPara.ParameterName = "areaId"; areaIdPara.DbType = DbType.String; areaIdPara.Value = input.AreaId; parameters.Add(areaIdPara); sql.Append(" and o.buyer_orgid = :orgId"); DbParameter orgIdPara = this.DbFacade.CreateParameter(); orgIdPara.ParameterName = "orgId"; orgIdPara.DbType = DbType.String; orgIdPara.Value = input.OrgId; parameters.Add(orgIdPara); //查询条件:订单状态 if (!String.IsNullOrEmpty(input.OrderState)) { sql.Append(" and o.order_state = :state"); DbParameter statePara = this.DbFacade.CreateParameter(); statePara.ParameterName = "state"; statePara.DbType = DbType.String; statePara.Value = input.OrderState; parameters.Add(statePara); } //查询条件:发送时间开始 if (!String.IsNullOrEmpty(input.StartDate)) { sql.Append(" and o.create_date>=CDate(:startDate) "); //sql.Append(" and o.create_date>=CDate(:startDate,'yyyy-mm-dd hh24:mi:ss') "); //sql.Append(input.StartDate); //sql.Append("','yyyy-mm-dd hh24:mi:ss') "); DbParameter startDatePara = this.DbFacade.CreateParameter(); startDatePara.ParameterName = "startDate"; startDatePara.DbType = DbType.String; startDatePara.Value = ComUtil.formatDate(input.StartDate); parameters.Add(startDatePara); } //查询条件:发送时间开始 if (!String.IsNullOrEmpty(input.EndDate)) { sql.Append(" and o.create_date<=CDate(:EndDate) "); DbParameter EndDatePara = this.DbFacade.CreateParameter(); EndDatePara.ParameterName = "EndDate"; EndDatePara.DbType = DbType.String; EndDatePara.Value = ComUtil.formatDate(input.EndDate); parameters.Add(EndDatePara); } ////查询条件:发送时间结束 //if (!String.IsNullOrEmpty(input.EndDate)) //{ // sql.Append(" and o.create_date<=CDate(':endDate') "); // //sql.Append(" and o.create_date<=to_date(:endDate,'yyyy-mm-dd hh24:mi:ss') "); // //sql.Append(input.EndDate); // //sql.Append("','yyyy-mm-dd hh24:mi:ss') "); // DbParameter endDatePara = this.DbFacade.CreateParameter(); // endDatePara.ParameterName = "endDate"; // endDatePara.DbType = DbType.String; // endDatePara.Value = ComUtil.formatDate(input.EndDate); // parameters.Add(endDatePara); //} //查询条件:创建人 if (!String.IsNullOrEmpty(input.Creater)) { sql.Append(" and UCase(o.create_username) like :creater"); DbParameter createrPara = this.DbFacade.CreateParameter(); createrPara.ParameterName = "creater"; createrPara.DbType = DbType.String; createrPara.Value = ComUtil.GetLike(input.Creater.ToUpper()); parameters.Add(createrPara); } //查询条件:1卖方企业或2订单号 if ("1".Equals(input.SearchField)) { if (!String.IsNullOrEmpty(input.SearchKey)) { sql.Append(" and UCase(o.SALER_NAME & o.SALER_EASY & o.SALER_FAST & o.SALER_WUBI) like :org "); DbParameter orgPara = this.DbFacade.CreateParameter(); orgPara.ParameterName = "org"; orgPara.DbType = DbType.String; orgPara.Value = ComUtil.GetLike(input.SearchKey.ToUpper()); parameters.Add(orgPara); } } if ("2".Equals(input.SearchField)) { if (!String.IsNullOrEmpty(input.SearchKey)) { sql.Append(" and UCase(o.order_code) like :code "); DbParameter codePara = this.DbFacade.CreateParameter(); codePara.ParameterName = "code"; codePara.DbType = DbType.String; codePara.Value = ComUtil.GetLike(input.SearchKey.ToUpper()); parameters.Add(codePara); } } sql.Append(" Group by o.saler_id"); sql.Append(" ) a,(Select Distinct b.org_id,b.Org_Name,b.Org_Easy From cont_org b) b"); sql.Append(" Where a.Saler_Id=b.Org_id"); input.Rows = base.GetRowCount(sql.ToString(), parameters.ToArray()); rows = input.Rows; //DbParameter highIndexPara = DbFacade.CreateParameter(); //highIndexPara.ParameterName = "highRowNum"; //highIndexPara.DbType = DbType.Int32; //highIndexPara.Value = input.End; //parameters.Add(highIndexPara); //DbParameter lowIndexPara = DbFacade.CreateParameter(); //lowIndexPara.ParameterName = "lowRowNum"; //lowIndexPara.DbType = DbType.Int32; //lowIndexPara.Value = input.Start; //parameters.Add(lowIndexPara); DataTable tb = base.DbFacade.SQLExecuteDataTable(sql.ToString(), parameters.ToArray()); ds.Tables.Add(tb); } catch (Exception e) { throw e; } return(ds); }
/// <summary> /// 关闭订单 /// </summary> public void CloseOrderItem(BuyerOrderModel input) { dao.CloseOrderItem(input); }
/// <summary> /// 订单明细完成 /// </summary> public void CompleteOrderItem(BuyerOrderModel input) { dao.CompleteOrderItem(input); }
private void btnCloseOrder_Click(object sender, EventArgs e) { try { if (input != null) { input.List.Clear(); } else { input = new BuyerOrderModel(); input.UserId = base.CurrentUserId; input.UserName = base.CurrentUserName; input.SalerId = base.CurrentUserRegOrgId; input.AreaId = base.CurrentUserSingleRegionId; input.OrderId = orderModel.Id; input.Remark = this.rtbRemarkA.Text; } int rowCount = 0; for (int i = 0; i < gridView3.RowCount; i++) { DataRow row = gridView3.GetDataRow(i); if (row["chk"] != null && row["chk"].ToString() == "1") { rowCount++; } } if (rowCount < 1) { XtraMessageBox.Show("请选择记录后再进行操作!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } for (int i = 0; i < gridView3.RowCount; i++) { DataRow row = gridView3.GetDataRow(i); if (row["chk"] != null && row["chk"].ToString() == "1") { OrderItemModel item = new OrderItemModel(); item.StockupId = row["Stockup_Id"].ToString(); item.Order_item_id = row["id"].ToString(); item.RequestQty = row["Request_Qty"].ToString(); item.LotNo = row["Lot_No"].ToString(); item.ReceiveQty = row["Receive_Qty"].ToString(); item.BuyerId = row["buyer_Id"].ToString(); item.BuyerName = row["buyer_Name"].ToString(); item.BuyerNameAbbr = row["buyer_Name_Abbr"].ToString(); item.SalerId = row["saler_Id"].ToString(); item.SalerName = row["saler_Name"].ToString(); item.SalerNameAbbr = row["saler_Name_Abbr"].ToString(); item.SenderId = row["sender_Id"].ToString(); item.SenderName = row["sender_Name"].ToString(); item.SenderNameAbbr = row["sender_Name_Abbr"].ToString(); item.ManuId = row["MANUFACTURE_ID"].ToString(); item.ManuName = row["MANUFACTURE_NAME"].ToString(); item.ManuNameAbbr = row["MANUFACTURE_NAME_ABBR"].ToString(); item.ProductName = row["product_Name"].ToString(); item.ProductCode = row["product_Code"].ToString(); item.Spec_id = row["spec_id"].ToString(); item.Model_id = row["model_id"].ToString(); item.Spec = row["spec"].ToString(); item.Model = row["model"].ToString(); item.CommonName = row["common_Name"].ToString(); item.Brand = row["brand"].ToString(); item.BaseMeasureSpec = row["base_Measure_Spec"].ToString(); item.BaseMeasureMater = row["base_Measure_Mater"].ToString(); item.BaseMeasure = row["base_Measure"].ToString(); item.Send_measure_ex = row["send_measure_ex"].ToString(); item.Send_measure = row["send_measure"].ToString(); item.ProductId = row["PROJECT_PROD_ID"].ToString(); item.TradePrice = row["trade_Price"].ToString(); item.RetailPrice = row["RETAIL_PRICE"].ToString(); item.Project_id = row["project_id"].ToString(); item.Project_product_id = row["PROJECT_PROD_ID"].ToString(); item.Pbno = row["Pbno"].ToString(); item.Send_batch_no = row["Send_batch_no"].ToString(); item.Store_room_id = row["store_room_id"].ToString(); item.Store_room_name = row["store_room_name"].ToString(); input.List.Add(item); } } //end modify BuyerOrderOfflineBLL.GetInstance().CloseOrderItem(input); int rows; DataSet ds = null; ds = BuyerOrderOfflineBLL.GetInstance().GetNoArriveList(orderModel, input, out rows); this.bindingSourceNoArrive.DataSource = null; this.bindingSourceNoArrive.DataSource = ds.Tables[0]; //string overSum = BuyerOrderOfflineDAO.GetInstance().GetOrderOverSum(input.OrderId); //orderModel.Over_sum = overSum; string state = BuyerOrderOfflineDAO.GetInstance().GetOrderState(input.OrderId); orderModel.OrderState = state; this.lcPurchaseState.Text = orderModel.OrderState; //this.lcTotalFinish.Text = SetNumFormat(orderModel.Over_sum) + "元"; } catch (Exception ex) { throw ex; } XtraMessageBox.Show("操作成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void btnAffirm_Click(object sender, EventArgs e) { try { if (input != null) { input.List.Clear(); } else { input = new BuyerOrderModel(); input.UserId = base.CurrentUserId; input.UserName = base.CurrentUserName; input.SalerId = base.CurrentUserRegOrgId; input.AreaId = base.CurrentUserSingleRegionId; input.OrderId = orderModel.Id; input.Remark = this.rtbRemarkA.Text; input.HighId = ClientSession.GetInstance().CurrentUser.HighId;; } int rowCount = 0; for (int i = 0; i < gridView3.RowCount; i++) { DataRow row = gridView3.GetDataRow(i); if (row["chk"] != null && row["chk"].ToString() == "1") { rowCount++; } } if (rowCount < 1) { XtraMessageBox.Show("请选择记录后再进行操作!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } //if (!checkInput()) // return; for (int i = 0; i < gridView3.RowCount; i++) { DataRow row = gridView3.GetDataRow(i); if (row["chk"] != null && row["chk"].ToString() == "1") { OrderItemModel item = new OrderItemModel(); item.StockupId = row["Stockup_Id"].ToString(); item.RequestQty = row["Request_Qty"].ToString(); item.LotNo = row["Lot_No"].ToString(); item.ReceiveQty = row["Receive_Qty"].ToString(); item.Order_item_id = row["id"].ToString(); item.ProductId = row["Product_Id"].ToString(); //item.Amount = row["amount"].ToString(); //item.Discount = dgvNoArrive.Rows[i].Cells["discount"].Value.ToString(); //item.InvoiceDate = dgvNoArrive.Rows[i].Cells["invoiceDate"].Value.ToString(); //item.InvoiceExpireDate = dgvNoArrive.Rows[i].Cells["invoiceExpireDate"].Value.ToString(); //item.InvoiceNo = dgvNoArrive.Rows[i].Cells["invoiceNo"].Value.ToString(); //item.ReceiveRemark = dgvNoArrive.Rows[i].Cells["receiveRemark"].Value.ToString(); //item.RepositoryId = dgvNoArrive.Rows[i].Cells["repositoryId"].Value.ToString(); item.RetailPrice = row["RETAIL_PRICE"].ToString(); item.TradePrice = row["trade_Price"].ToString(); item.Project_id = row["project_id"].ToString(); item.Project_product_id = row["project_prod_id"].ToString(); item.Pbno = row["pbno"].ToString(); item.Send_batch_no = row["send_batch_no"].ToString(); item.Store_room_id = row["store_room_id"].ToString(); item.Store_room_name = row["store_room_name"].ToString(); item.BuyerId = row["buyer_Id"].ToString(); item.BuyerName = row["buyer_Name"].ToString(); item.BuyerNameAbbr = row["buyer_Name_Abbr"].ToString(); item.SalerId = row["saler_Id"].ToString(); item.SalerName = row["saler_Name"].ToString(); item.SalerNameAbbr = row["saler_Name_Abbr"].ToString(); item.SenderId = row["sender_Id"].ToString(); item.SenderName = row["sender_Name"].ToString(); item.SenderNameAbbr = row["sender_Name_Abbr"].ToString(); item.ManuId = row["MANUFACTURE_ID"].ToString(); item.ManuName = row["MANUFACTURE_NAME"].ToString(); item.ManuNameAbbr = row["MANUFACTURE_NAME_ABBR"].ToString(); item.ProductName = row["product_Name"].ToString(); item.ProductCode = row["product_Code"].ToString(); item.Spec_id = row["spec_id"].ToString(); item.Model_id = row["model_id"].ToString(); item.Spec = row["spec"].ToString(); item.Model = row["model"].ToString(); item.CommonName = row["common_Name"].ToString(); item.Brand = row["brand"].ToString(); item.BaseMeasureSpec = row["base_Measure_Spec"].ToString(); item.BaseMeasureMater = row["base_Measure_Mater"].ToString(); item.BaseMeasure = row["base_Measure"].ToString(); item.Send_measure_ex = row["send_measure_ex"].ToString(); item.Send_measure = row["send_measure"].ToString(); item.ProductId = row["PROJECT_PROD_ID"].ToString(); item.RetailPrice = row["RETAIL_PRICE"].ToString(); item.Project_id = row["project_id"].ToString(); item.Project_product_id = row["PROJECT_PROD_ID"].ToString(); item.Pbno = row["Pbno"].ToString(); item.Send_batch_no = row["Send_batch_no"].ToString(); item.Store_room_id = row["store_room_id"].ToString(); item.Store_room_name = row["store_room_name"].ToString(); input.List.Add(item); } } BuyerOrderOfflineBLL.GetInstance().ArrivedConfirm(input); int rows; DataSet ds = null; ds = BuyerOrderOfflineBLL.GetInstance().GetNoArriveList(orderModel, input, out rows); string overSum = BuyerOrderOfflineDAO.GetInstance().GetOrderOverSum(input.OrderId); orderModel.Over_sum = overSum; string state = BuyerOrderOfflineDAO.GetInstance().GetOrderState(input.OrderId); orderModel.OrderState = state; this.lcPurchaseState.Text = orderModel.OrderState; this.lcTotalFinish.Text = SetNumFormat(orderModel.Over_sum) + "元"; input.Rows = rows; this.bindingSourceNoArrive.DataSource = null; this.bindingSourceNoArrive.DataSource = ds.Tables[0]; //string temp = string.Empty; //string state = string.Empty; // temp = BuyerOrderOfflineBLL.GetInstance("ClientDB").GetReceiveTotalByOrder(input); // state = BuyerOrderOfflineBLL.GetInstance("ClientDB").GetOrderState(input); //this.orderTitle.lblReceive.Text = temp.Trim() + "(元)"; //this.orderTitle.lblState.Text = state; if (ds.Tables[0].Rows.Count == 0) { this.rtbRemarkA.Text = ""; } } catch (Exception ex) { throw ex; } XtraMessageBox.Show("操作成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); }
/// <summary> /// 获取未到货列表数据 /// </summary> public DataSet GetNoArriveList(OrderModel input, BuyerOrderModel orderInput, out int rows) { return(dao.GetNoArriveList(input, orderInput, out rows)); }
/// <summary> /// 取得按企业到货列表数据 /// </summary> public DataSet GetBuyerOrderByOrgList(BuyerOrderModel input, out int rows) { return(dao.GetBuyerOrderByOrgList(input, out rows)); }