private void onSearch(v_lhproducts_policyModel where)
{
var action = new Action(() =>
{
PageResult <v_lhproducts_policyModel> result = null;
string countStr = $"第【{page}】页/共【{count}】页";
try
{
btnNext.Enabled = btnLast.Enabled = btn查询.Enabled = btn重置.Enabled = btnConfirm.Enabled = btnReturn.Enabled = false;
result = _service.GetPolicyProducts(header, where, page, size);
total = result.Total;
count = total / size;
count += total % size > 0 ? 1 : 0;
countStr = $"第【{page}】页/共【{count}】页";
labCount.Text = countStr;
gridControl.DataSource = result.Result;
btnNext.Enabled = btnLast.Enabled =
btn查询.Enabled = btn重置.Enabled = btnConfirm.Enabled = btnReturn.Enabled = true;
}
catch (Exception e)
{
MsgHelper.ShowInformation(e.Message);
}
});
var t1 = new ThreadStart(action);
t1.Invoke();
}
private V_ICPOBILLENTRYMODEL PolicyProductToICPOBillEntry(v_lhproducts_policyModel data)
{
V_ICPOBILLENTRYMODEL result = new V_ICPOBILLENTRYMODEL();
result.FITEMID = data.PRODCODE;
result.FPRODUCTNAME = data.PRODNAME;
result.FPRODUCTTYPE = data.LHPRODTYPE;
result.FPRODUCTCODE = data.PRODCODE;
result.FSRCQTY = 0;
result.Famount = result.FPRICE * result.FSRCQTY;
result.FSRCNAME = "";
result.FSRCMODEL = data.LHPRODTYPE + "||" + data.PRODSTANDARD + "||" + data.PRODMODEL;
result.FSRCCODE = data.PRODCODE;
result.MINIMUMQUANTITY = data.MINIMUMQUANTITY;
result.CAPPINGQUANTITY = data.CAPPINGQUANTITY;
result.DISCOUNTRATE = data.DISCOUNTRATE;
result.LH_DCTPOLICYROWTYPE = data.POLICYITEMTYPE;
result.LH_DCTPOLICYPRODNAME = data.PRODNAME;
if (data.SPECIALOFFER != null)
{
result.FPRICE = data.SPECIALOFFER.Value;
}
result.LH_DCTPOLICYITEMID = data.ITEMID;
return(result);
}
private v_lhproducts_policyModel GetWhere()
{
var where = new v_lhproducts_policyModel();
where.PRODNAME = txtFactoryName.Text;
where.PRODMODEL = txtFactoryModel.Text;
where.PRODSTANDARD = txtSpecifications.Text;
return(where);
}
private void gridControl_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
var list = new List <v_lhproducts_policyModel>(gridControl.DataSource as v_lhproducts_policyModel[]);
this.SelectData = list[gridView名称代码.GetDataSourceRowIndex(gridView名称代码.FocusedRowHandle)];
this.SelectID = gridView名称代码.GetRowCellValue(gridView名称代码.FocusedRowHandle, "HEADID").ToString();
this.SelectName = gridView名称代码.GetRowCellValue(gridView名称代码.FocusedRowHandle, "POLICYNAME").ToString();
this.DialogResult = DialogResult.OK;
this.Close();
}
}
public PageResult <v_lhproducts_policyModel> GetPolicyProducts(ICPOBILL_PolicyDTO header,
v_lhproducts_policyModel where, int index = 1, int size = 35)
{
where = ComputeWhere(header, where);
var helper = new OracleDBHelper();
var total = 0;
string whereStr = helper.GetWhereStr(where);
List <v_lhproducts_policyModel> resultList = new List <v_lhproducts_policyModel>();
if (string.IsNullOrEmpty(header.HeadID))
{
List <V_LHPRODUCTS_UNPOLICYHEADID> data =
helper.GetWithWhereStrByPage <V_LHPRODUCTS_UNPOLICYHEADID>(whereStr, where, index, size);
total = helper.Count <V_LHPRODUCTS_UNPOLICYHEADID>(whereStr);
var t = typeof(V_LHPRODUCTS_UNPOLICYHEADID);
var pis = t.GetProperties().ToList();
data.ForEach(p =>
{
var item = new v_lhproducts_policyModel();
pis.ForEach(pi =>
{
var value = pi.GetValue(p, null);
pi.SetValue(item, value);
});
resultList.Add(item);
});
}
else
{
List <v_lhproducts_policyModel> data =
helper.GetWithWhereStrByPage <v_lhproducts_policyModel>(whereStr, where, index, size);
total = helper.Count <v_lhproducts_policyModel>(whereStr);
resultList = data;
}
PageResult <v_lhproducts_policyModel> result = new PageResult <v_lhproducts_policyModel>()
{
Total = total, Result = resultList
};
return(result);
}
private v_lhproducts_policyModel ComputeWhere(ICPOBILL_PolicyDTO header, v_lhproducts_policyModel where)
{
CheckNull(header);
where.LHPRODTYPE = header.BrandName;
switch (header.OrderType)
{
//常规订单
case "Common":
{
where.LHPRODSIGN = "成品";
break;
}
//配件订单
case "Parts":
{
where.LHPRODSIGN = "配件";
break;
}
//广告物料申请单
case "Advertise":
{
where.LHPRODSIGN = "广告物料";
where.LHPRODTYPE = "广告用品";
break;
}
}
where.HEADID = string.IsNullOrEmpty(header.HeadID) ? null : header.HeadID;
if (!string.IsNullOrEmpty(header.HeadID))
{
where.DEPTNAME = header.BrandName.Contains("事业部") ? header.BrandName : $"{header.BrandName}事业部";
where.ORDERTYPE = header.OrderType;
where.ORDERSUBTYPE = header.OrderSubType;
where.ACCTCODES = header.Account;
}
where.LHPRODCHANNEL = header.Channel;
return(where);
}
public PageResult <v_lhproducts_policyModel> GetPolicyProducts(ICPOBILL_PolicyDTO header,
v_lhproducts_policyModel where, int index = 1, int size = 35)
{
return(methods.GetPolicyProducts(header, where, index, size));
}
