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