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