/// <summary>
/// 设置检索结果对象
/// </summary>
/// <param name="reader">记录集合</param>
/// <returns>检索结果对象</returns>
private SalerOrderItemModel MapSalerOrderItem1(IDataReader reader)
{
SalerOrderItemModel model = new SalerOrderItemModel();
model.BuyerDesc = reader["receiveremark"].ToString();
model.UnitPrice = reader["provide_price"].ToString();
model.BakMedicalName = reader["medicalname"].ToString();
model.BakProductName = reader["tradename"].ToString();
model.BakFactoryEasy = reader["factoryshortname"].ToString();
model.BakFactoryName = reader["factoryfullname"].ToString();
model.RequestQty = reader["requestqty"].ToString();
model.BakProductSpec = reader["ggbz"].ToString();
model.OrderStateName = reader["itemstatus"].ToString();
model.OrderType = reader["ordertype"].ToString();
//model.RecordId = reader["record_id"].ToString();
//model.ProductId = reader["product_id"].ToString();
//model.OrderId = reader["order_id"].ToString();
//model.OrderItemState = reader["item_status"].ToString();
//model.PlatId = reader["plat_id"].ToString();
//model.DegreeFlag = reader["degree_flag"].ToString();
//model.BuyerOrgid = reader["buyer_orgid"].ToString();
//model.BakBuyerName = reader["bakBuyerName"].ToString();
//model.SalerOrgid = reader["saler_orgid"].ToString();
//model.SenderOrgid = reader["sender_orgid"].ToString();
//model.AgentOrgid = reader["agent_orgid"].ToString();
//model.BakMedicalId = reader["bak_medical_id"].ToString();
//model.BakMedicalMode = reader["bak_medical_mode"].ToString();
//model.ProductId = reader["product_id"].ToString();
//model.BakProductBidWay = reader["bak_product_bid_way"].ToString();
//model.BakFactoryId = reader["bak_factory_id"].ToString();
//model.MetricName = reader["metric_name"].ToString();
//model.ReceiveQty = reader["receive_qty"].ToString();
//model.SourceType = reader["source_type"].ToString();
//model.SourceProjectId = reader["source_project_id"].ToString();
//model.BakMedicalSpec = reader["bak_medical_spec"].ToString();
//model.MiddleStandRate = reader["middle_stand_rate"].ToString();
//start modify by gaoyuan 2007.1.11
//model.BakMedicalSpec = Convert.ToString((Convert.ToInt32(reader["middle_stand_rate"].ToString()) * Convert.ToInt32(reader["big_middle_rate"].ToString())));
//model.BigMiddleRate = reader["middle_stand_rate"].ToString() + "/" +Convert.ToString((Convert.ToInt32(reader["middle_stand_rate"].ToString()) * Convert.ToInt32(reader["big_middle_rate"].ToString())));
//end modify by gaoyuan 2007.1.11
//model.BakMassAssignment = reader["bak_mass_assignment"].ToString();
//model.ReadyFlag = string.IsNullOrEmpty(reader["ready_flag"].ToString()) ? "0" : reader["ready_flag"].ToString();
//model.ReadyQty = reader["ready_qty"].ToString();
//model.RepositoryName = reader["warehouse_name"].ToString();
//model.WrapName = dao.getWrapName(reader["product_id"].ToString());
//model.RequestTotal = reader["request_total"].ToString();
//model.RepositoryId = reader["repository_id"].ToString();
//model.MaxQty = reader["maxQty"].ToString();
return(model);
}
/// <summary>
/// 取得订单信息
/// </summary>
/// <param name="orderId"></param>
/// <returns></returns>
//public SalerOrderModel GetOrderTitle(string orderId)
//{
// return dao.GetOrderTitle(orderId);
//}
//刘海超2007-8-8
/// <summary>
/// 设置检索结果对象
/// </summary>
/// <param name="reader">记录集合</param>
/// <returns>检索结果对象</returns>
private SalerOrderItemModel MapSalerOrderItem1(IDataReader reader)
{
SalerOrderItemModel model = new SalerOrderItemModel();
model.BuyerDesc = reader["receiveremark"].ToString();
model.UnitPrice = reader["provide_price"].ToString();
model.BakMedicalName = reader["medicalname"].ToString();
model.BakProductName = reader["tradename"].ToString();
model.BakFactoryEasy = reader["factoryshortname"].ToString();
model.BakFactoryName = reader["factoryfullname"].ToString();
model.RequestQty = reader["requestqty"].ToString();
model.BakProductSpec = reader["ggbz"].ToString();
model.OrderStateName = reader["itemstatus"].ToString();
model.OrderType = reader["ordertype"].ToString();
return(model);
}
/// <summary>
/// 设置检索结果对象
/// </summary>
/// <param name="reader">记录集合</param>
/// <returns>检索结果对象</returns>
private SalerOrderItemModel MapSalerOrderItem(DataRow reader)
{
SalerOrderItemModel model = new SalerOrderItemModel();
model.RecordId = reader["record_id"].ToString();
model.ProductId = reader["product_id"].ToString();
model.OrderId = reader["order_id"].ToString();
model.OrderItemState = reader["item_status"].ToString();
model.BuyerDesc = reader["buyer_remark"].ToString();
model.UnitPrice = reader["provide_price"].ToString();
model.BakMedicalName = reader["medical_name"].ToString();
model.BakProductName = reader["trade_name"].ToString();
model.ProductId = reader["product_id"].ToString();
model.BakFactoryEasy = reader["factory_easy"].ToString();
model.BakFactoryName = reader["factory_name"].ToString();
model.RequestQty = reader["request_qty"].ToString();
model.RepositoryName = reader["warehouse_name"].ToString();
model.BakProductSpec = reader["ggbz"].ToString();
model.OrderStateName = reader["status"].ToString();
model.RepositoryId = reader["repository_id"].ToString();
model.MaxQty = reader["maxQty"].ToString();
model.InvoiceTradePrice = model.UnitPrice;
model.InvoiceRetailPrice = model.UnitPrice;
model.InvoiceDiscountRate = "100";
model.InvoiceTotal = Convert.ToString(Convert.ToDouble(model.RequestQty) * Convert.ToDouble(model.UnitPrice));
model.InvoiceDate = Convert.ToString(DateTime.Now.Date);
model.InvoiceExpireDate = Convert.ToString(DateTime.Now.Date);
if (model.OrderItemState.Equals("6"))
{
model.CheckBoxShow = "0";
}
else
{
model.CheckBoxShow = "1";
}
return(model);
}
/// <summary>
/// 设置发货信息
/// </summary>
/// <param name="dgvr"></param>
/// <param name="result"></param>
private void setOrderItem(DataGridViewRow dgvr, IList result)
{
SalerOrderItemModel model = new SalerOrderItemModel();
model.ProductId = dgvr.Cells["EmedProductCode"].Value.ToString();
model.LotNo = dgvr.Cells["LOT_NO"].Value.ToString();
model.ReceiveQty1 = dgvr.Cells["RECEIVE_QTY"].Value.ToString();
model.InvoiceNo = dgvr.Cells["INVOICE_NO"].Value.ToString();
model.InvoiceDate = dgvr.Cells["INVOICE_DATE"].Value.ToString();
model.InvoiceTotal = dgvr.Cells["INVOICE_TOTAL"].Value.ToString();
model.InvoiceExpireDate = dgvr.Cells["INVOICE_EXPIRE_DATE"].Value.ToString();
model.AppNum = dgvr.Cells["PERMIT_NO"].Value.ToString();
model.InvoiceTradePrice = dgvr.Cells["INVOICE_TRADE_PRICE"].Value.ToString();
model.InvoiceRetailPrice = dgvr.Cells["INVOICE_RETAIL_PRICE"].Value.ToString();
model.InvoiceDiscountRate = dgvr.Cells["INVOICE_DISCOUNT_RATE"].Value.ToString();
model.ReadyRemark = dgvr.Cells["READY_REMARK"].Value.ToString();
model.ReceiveQty = dgvr.Cells["RECEIVE_QTY"].Value.ToString();
model.IsChecked = true;
model.OrderItemState = "1";
model.RecordId = dgvr.Cells["ordItemId"].Value.ToString();
result.Add(model);
}
/// <summary>
/// 设置检索结果对象
/// </summary>
/// <param name="reader">记录集合</param>
/// <returns>检索结果对象</returns>
private SalerOrderItemModel MapSalerOrderItem(IDataReader reader)
{
SalerOrderItemModel model = new SalerOrderItemModel();
model.RecordId = reader["record_id"].ToString();
model.ProductId = reader["product_id"].ToString();
model.OrderId = reader["order_id"].ToString();
model.OrderItemState = reader["item_status"].ToString();
model.BuyerDesc = reader["buyer_remark"].ToString();
model.UnitPrice = reader["provide_price"].ToString();
model.BakMedicalName = reader["medical_name"].ToString();
model.BakProductName = reader["trade_name"].ToString();
model.ProductId = reader["product_id"].ToString();
model.BakFactoryEasy = reader["factory_easy"].ToString();
model.BakFactoryName = reader["factory_name"].ToString();
model.RequestQty = reader["request_qty"].ToString();
model.RepositoryName = reader["warehouse_name"].ToString();
model.BakProductSpec = reader["ggbz"].ToString();
model.OrderStateName = reader["status"].ToString();
model.RepositoryId = reader["repository_id"].ToString();
model.MaxQty = reader["maxQty"].ToString();
model.InvoiceTradePrice = model.UnitPrice;
model.InvoiceRetailPrice = model.UnitPrice;
model.InvoiceDiscountRate = "100";
model.InvoiceTotal = Convert.ToString(Convert.ToDouble(model.RequestQty) * Convert.ToDouble(model.UnitPrice));
model.InvoiceDate = Convert.ToString(DateTime.Now.Date);
model.InvoiceExpireDate = Convert.ToString(DateTime.Now.Date);
//model.PlatId = reader["plat_id"].ToString();
//model.DegreeFlag = reader["degree_flag"].ToString();
//model.BuyerOrgid = reader["buyer_orgid"].ToString();
//model.BakBuyerName = reader["bakBuyerName"].ToString();
//model.SalerOrgid = reader["saler_orgid"].ToString();
//model.SenderOrgid = reader["sender_orgid"].ToString();
//model.AgentOrgid = reader["agent_orgid"].ToString();
//model.BakMedicalId = reader["bak_medical_id"].ToString();
//model.BakMedicalMode = reader["bak_medical_mode"].ToString();
//model.BakProductBidWay = reader["bak_product_bid_way"].ToString();
//model.BakFactoryId = reader["bak_factory_id"].ToString();
//model.MetricName = reader["metric_name"].ToString();
//model.ReceiveQty = reader["receive_qty"].ToString();
//model.SourceType = reader["source_type"].ToString();
//model.SourceProjectId = reader["source_project_id"].ToString();
//model.BakMedicalSpec = reader["bak_medical_spec"].ToString();
//model.MiddleStandRate = reader["middle_stand_rate"].ToString();
//start modify by gaoyuan 2007.1.11
//model.BakMedicalSpec = Convert.ToString((Convert.ToInt32(reader["middle_stand_rate"].ToString()) * Convert.ToInt32(reader["big_middle_rate"].ToString())));
//model.BigMiddleRate = reader["middle_stand_rate"].ToString() + "/" +Convert.ToString((Convert.ToInt32(reader["middle_stand_rate"].ToString()) * Convert.ToInt32(reader["big_middle_rate"].ToString())));
//end modify by gaoyuan 2007.1.11
//model.BakMassAssignment = reader["bak_mass_assignment"].ToString();
//model.ReadyFlag = string.IsNullOrEmpty(reader["ready_flag"].ToString()) ? "0" : reader["ready_flag"].ToString();
//model.ReadyQty = reader["ready_qty"].ToString();
//model.WrapName = dao.getWrapName(reader["product_id"].ToString());
//model.RequestTotal = reader["request_total"].ToString();
if (model.OrderItemState.Equals("6"))
{
model.CheckBoxShow = "0";
}
else
{
model.CheckBoxShow = "1";
}
return(model);
}