private void Show()
{
string sql = "";
if (txtPONo.Text.Trim() != "")
{
if (CheckPoNO(txtPONo.Text) == false)
{
return;
}
sql += string.Format(" and tb.PONo like '%{0}%'", txtPONo.Text.Trim());
}
if (ttxPOName.Text.Trim() != "")
{
sql += string.Format(" and POName like '%{0}%'", ttxPOName.Text.Trim());
}
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('销退时间 格式错误！');</script>");
return;
}
sql += string.Format(" and RuTime>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('销退时间 格式错误！');</script>");
return;
}
sql += string.Format(" and RuTime<='{0} 23:59:59'", txtTo.Text);
}
if (txtGuestName.Text.Trim() != "")
{
sql += string.Format(" and GuestNAME like '%{0}%'", txtGuestName.Text.Trim());
}
if (ddlUser.Text != "-1")
{
sql += string.Format(" and AE='{0}'", ddlUser.SelectedItem.Text);
}
if (ddlCompany.Text != "-1")
{
string where = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[2]);
sql += string.Format(" and AE IN(select loginName from tb_User where {0})", where);
}
if (ddlNormal.Text != "-1")
{
sql += string.Format(" and IsNormal={0}", ddlNormal.Text);
}
if (txtGoodNo.Text != "" || txtNameOrTypeOrSpec.Text != "" || txtNameOrTypeOrSpecTwo.Text != "")
{
if (txtGoodNo.Text != "")
{
sql += string.Format(" and TB_Good.GoodNo like '%{0}%'", txtGoodNo.Text);
}
if (txtNameOrTypeOrSpec.Text != "" && txtNameOrTypeOrSpecTwo.Text != "")
{
sql += string.Format(" and ((GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%') or (GoodTypeSmName like '%{1}%' or GoodName like '%{1}%' or GoodSpec like '%{1}%'))",
txtNameOrTypeOrSpec.Text, txtNameOrTypeOrSpecTwo.Text);
}
else if (txtNameOrTypeOrSpec.Text != "" || txtNameOrTypeOrSpecTwo.Text != "")
{
var NameOrTypeOrSpec = "";
if (txtNameOrTypeOrSpec.Text != "")
{
NameOrTypeOrSpec = txtNameOrTypeOrSpec.Text;
}
if (txtNameOrTypeOrSpecTwo.Text != "")
{
NameOrTypeOrSpec = txtNameOrTypeOrSpecTwo.Text;
}
sql += string.Format(" and (GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%')",
NameOrTypeOrSpec);
}
}
if (ddlIsSpecial.Text != "-1")
{
sql += string.Format(" and IsSpecial={0} ", ddlIsSpecial.Text);
}
if (ddlIsClose.Text != "-1")
{
sql += string.Format(" and IsClose={0} ", ddlIsClose.Text);
}
if (ddlIsSelect.Text != "-1")
{
sql += string.Format(" and IsSelected={0} ", ddlIsSelect.Text);
}
if (ddlJieIsSelected.Text != "-1")
{
sql += string.Format(" and JieIsSelected={0} ", ddlJieIsSelected.Text);
}
if (ddlModel.Text != "全部")
{
sql += string.Format(" and Model='{0}'", ddlModel.Text);
}
if (ddlTui.Text == "2")
{
sql += string.Format(" and tb.GoodNum=tb1.CaiGoodNum ", ddlJieIsSelected.Text);
}
if (ddlTui.Text == "1")
{
sql += string.Format(" and (tb.GoodNum<>tb1.CaiGoodNum or tb1.CaiGoodNum is null )", ddlJieIsSelected.Text);
}
List <Sell_Cai_OrderInHouseListModel> pOOrderList = this.POSer.GetSell_Cai_OrderInHouseListArray(sql);
//商品销售退货合计-采购退货合计<0--不正常（浅灰色）
if (ddlFenXi.Text == "1")
{
pOOrderList = pOOrderList.FindAll(model => model.GoodNum - (model.CaiGoodNum ?? 0) < 0);
}
//商品销售退货合计-采购退货合计=0--正常（浅黄色）
if (ddlFenXi.Text == "2")
{
pOOrderList = pOOrderList.FindAll(model => model.GoodNum - (model.CaiGoodNum ?? 0) == 0);
}
//项目中该商品数量合计-采购退货合计>=（销售退货合计-采购退货合计）×2 且采购单为库存的数量>=销售退货合计-采购退货合计-正常（浅绿色）
if (ddlFenXi.Text == "3")
{
pOOrderList = pOOrderList.FindAll(model => !(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0) &&
model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0)));
}
//项目中该商品数量合计-采购退货合计<（销售退货合计-采购退货合计）×2 -正常库存消零（土黄色）
if (ddlFenXi.Text == "4")
{
pOOrderList = pOOrderList.FindAll(model =>
!(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0));
pOOrderList = pOOrderList.FindAll(model => model.NeedNums > 0);
//销售退货有有一次是库存为0 的 判断
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList = jxcDetailSer.GetListArray_New_Good(pOOrderList);
}
//修改成项目中该商品数量合计-采购退货合计>=（销售退货合计-采购退货合计）×2 -正常库存消零
if (ddlFenXi.Text == "4.1")
{
pOOrderList = pOOrderList.FindAll(model => !(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0));
pOOrderList = pOOrderList.FindAll(model => !(model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0))));
pOOrderList = pOOrderList.FindAll(model => model.NeedNums <= 0);
//销售退货有有一次是库存为0 的 判断
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList = jxcDetailSer.GetListArray_New_Good(pOOrderList);
}
//项目中该商品数量合计-采购退货合计>=（销售退货合计-采购退货合计）×2 且采购单为库存的数量<销售退货合计-采购退货合计--不正常有库存（淡红色）
if (ddlFenXi.Text == "5")
{
pOOrderList = pOOrderList.FindAll(model =>
!(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0) &&
model.NeedNums <= 0 && model.CaiNums < (model.GoodNum - (model.CaiGoodNum ?? 0)));
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList = jxcDetailSer.GetListArray_New_Good_Out(pOOrderList);
}
//项目中该商品数量合计-采购退货合计<（销售退货合计-采购退货合计）×2 -不正常库存不为零（红色）
if (ddlFenXi.Text == "6")
{
pOOrderList = pOOrderList.FindAll(model =>
!(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0) && //1,2
model.NeedNums > 0);
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList = jxcDetailSer.GetListArray_New_Good_Out(pOOrderList);
}
//正常
if (ddlFenXi.Text == "7")
{
var pOOrderList1 = pOOrderList.FindAll(model => model.GoodNum - (model.CaiGoodNum ?? 0) == 0);
var pOOrderList2 = pOOrderList.FindAll(model => !(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0) &&
model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0)));
pOOrderList = pOOrderList.FindAll(model =>
!(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0));
//4
var pOOrderList3 = pOOrderList.FindAll(model => model.NeedNums > 0);
//销售退货有有一次是库存为0 的 判断
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList3 = jxcDetailSer.GetListArray_New_Good(pOOrderList3);
//4.1
pOOrderList = pOOrderList.FindAll(model => !(model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0))));
pOOrderList = pOOrderList.FindAll(model => model.NeedNums <= 0);
//销售退货有有一次是库存为0 的 判断
pOOrderList = jxcDetailSer.GetListArray_New_Good(pOOrderList);
pOOrderList.AddRange(pOOrderList1);
pOOrderList.AddRange(pOOrderList2);
pOOrderList.AddRange(pOOrderList3);
}
//不正常
if (ddlFenXi.Text == "8")
{
var pOOrderList_1 = pOOrderList.FindAll(model => (model.GoodNum - (model.CaiGoodNum ?? 0) < 0)
);
var pOOrderList2 = pOOrderList.FindAll(model =>
!(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0) &&
model.NeedNums <= 0 && model.CaiNums < (model.GoodNum - (model.CaiGoodNum ?? 0)));
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList2 = jxcDetailSer.GetListArray_New_Good_Out(pOOrderList2);
pOOrderList = pOOrderList.FindAll(model =>
!(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0) && //1,2
model.NeedNums > 0);
pOOrderList = jxcDetailSer.GetListArray_New_Good_Out(pOOrderList);
pOOrderList.AddRange(pOOrderList_1);
pOOrderList.AddRange(pOOrderList2);
}
lblSellTuiTotal_Sum.Text = pOOrderList.Sum(t => t.GoodPriceSecond).ToString();
lblCaiTuiTotal_Sum.Text = pOOrderList.Sum(t => t.CAIGoodPriceTotal).ToString();
AspNetPager1.RecordCount = pOOrderList.Count;
this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
}
private void Show()
{
string sql = "";
if (txtPONo.Text != "")
{
sql += string.Format(" and tb.PONo like '%{0}%'", txtPONo.Text);
}
if (ttxPOName.Text != "")
{
sql += string.Format(" and POName like '%{0}%'", ttxPOName.Text);
}
if (txtFrom.Text != "")
{
sql += string.Format(" and RuTime>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
sql += string.Format(" and RuTime<='{0} 23:59:59'", txtTo.Text);
}
if (txtGuestName.Text != "")
{
sql += string.Format(" and GuestNAME like '%{0}%'", txtGuestName.Text);
}
if (ddlUser.Text != "-1")
{
sql += string.Format(" and AE='{0}'", ddlUser.SelectedItem.Text);
}
if (txtGoodNo.Text != "" || txtNameOrTypeOrSpec.Text != "" || txtNameOrTypeOrSpecTwo.Text != "")
{
if (txtGoodNo.Text != "")
{
sql += string.Format(" and TB_Good.GoodNo like '%{0}%'", txtGoodNo.Text);
}
if (txtNameOrTypeOrSpec.Text != "" && txtNameOrTypeOrSpecTwo.Text != "")
{
sql += string.Format(" and ((GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%') or (GoodTypeSmName like '%{1}%' or GoodName like '%{1}%' or GoodSpec like '%{1}%'))",
txtNameOrTypeOrSpec.Text, txtNameOrTypeOrSpecTwo.Text);
}
else if (txtNameOrTypeOrSpec.Text != "" || txtNameOrTypeOrSpecTwo.Text != "")
{
var NameOrTypeOrSpec = "";
if (txtNameOrTypeOrSpec.Text != "")
{
NameOrTypeOrSpec = txtNameOrTypeOrSpec.Text;
}
if (txtNameOrTypeOrSpecTwo.Text != "")
{
NameOrTypeOrSpec = txtNameOrTypeOrSpecTwo.Text;
}
sql += string.Format(" and (GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%')",
NameOrTypeOrSpec);
}
}
if (ddlIsSpecial.Text != "-1")
{
sql += string.Format(" and IsSpecial={0} ", ddlIsSpecial.Text);
}
if (ddlIsClose.Text != "-1")
{
sql += string.Format(" and IsClose={0} ", ddlIsClose.Text);
}
if (ddlIsSelect.Text != "-1")
{
sql += string.Format(" and IsSelected={0} ", ddlIsSelect.Text);
}
if (ddlJieIsSelected.Text != "-1")
{
sql += string.Format(" and JieIsSelected={0} ", ddlJieIsSelected.Text);
}
if (ddlTui.Text == "2")
{
sql += string.Format(" and tb.GoodNum=tb1.CaiGoodNum ", ddlJieIsSelected.Text);
}
if (ddlTui.Text == "1")
{
sql += string.Format(" and (tb.GoodNum<>tb1.CaiGoodNum or tb1.CaiGoodNum is null )", ddlJieIsSelected.Text);
}
List <Sell_Cai_OrderInHouseListModel> pOOrderList = this.POSer.GetSell_Cai_OrderInHouseListArray(sql);
////商品数量合计》=（销售退货合计-采购退货合计）×2-----浅绿色-正常
//if (ddlFenXi.Text == "1")
//{
// pOOrderList = pOOrderList.FindAll(t => t.NeedNums <= 0 && (t.GoodNum - (t.CaiGoodNum ?? 0) >=0));
//}
////商品销售退货合计-采购退货合计<0----浅灰色-不正常
//if (ddlFenXi.Text == "2")
//{
// pOOrderList = pOOrderList.FindAll(model => (model.GoodNum - (model.CaiGoodNum ?? 0)<0));
//}
////商品数量合计<（销售退货合计-采购退货合计）×2------红色-不正常
//if (ddlFenXi.Text == "3")
//{
// pOOrderList = pOOrderList.FindAll(t => t.NeedNums > 0);
//}
//商品销售退货合计-采购退货合计<0--不正常（浅灰色）
if (ddlFenXi.Text == "1")
{
pOOrderList = pOOrderList.FindAll(model => model.GoodNum - (model.CaiGoodNum ?? 0) < 0);
}
//商品销售退货合计-采购退货合计=0--正常（浅黄色）
if (ddlFenXi.Text == "2")
{
//pOOrderList = pOOrderList.FindAll(model =>!(model.GoodNum - (model.CaiGoodNum ?? 0) < 0)&&model.GoodNum - (model.CaiGoodNum ?? 0) == 0);
pOOrderList = pOOrderList.FindAll(model => model.GoodNum - (model.CaiGoodNum ?? 0) == 0);
}
//项目中该商品数量合计-采购退货合计>=（销售退货合计-采购退货合计）×2 且采购单为库存的数量>=销售退货合计-采购退货合计-正常（浅绿色）
if (ddlFenXi.Text == "3")
{
pOOrderList = pOOrderList.FindAll(model => !(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0) &&
model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0)));
//pOOrderList = pOOrderList.FindAll(model => model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0)));
}
//项目中该商品数量合计-采购退货合计<（销售退货合计-采购退货合计）×2 -正常库存消零（土黄色）
if (ddlFenXi.Text == "4")
{
//pOOrderList = pOOrderList.FindAll(model =>
// !((model.GoodNum - (model.CaiGoodNum ?? 0) < 0)
// || (model.GoodNum - (model.CaiGoodNum ?? 0) == 0)
// || (model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0))))
// &&model.NeedNums > 0 && model.HouseGoodNum > (model.GoodNum - (model.CaiGoodNum ?? 0)));
pOOrderList = pOOrderList.FindAll(model =>
!(model.GoodNum - (model.CaiGoodNum ?? 0) <= 0));
pOOrderList = pOOrderList.FindAll(model => model.NeedNums > 0);
//销售退货有有一次是库存为0 的 判断
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList = jxcDetailSer.GetListArray_New(pOOrderList);
}
if (ddlFenXi.Text == "4.1")
{
pOOrderList = pOOrderList.FindAll(model =>
!(
(model.GoodNum - (model.CaiGoodNum ?? 0) < 0) ||
(model.GoodNum - (model.CaiGoodNum ?? 0) == 0)
));
pOOrderList = pOOrderList.FindAll(model => model.NeedNums <= 0);
//销售退货有有一次是库存为0 的 判断
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList = jxcDetailSer.GetListArray_New(pOOrderList);
}
//项目中该商品数量合计-采购退货合计>=（销售退货合计-采购退货合计）×2 且采购单为库存的数量<销售退货合计-采购退货合计--不正常有库存（淡红色）
if (ddlFenXi.Text == "5")
{
pOOrderList = pOOrderList.FindAll(model =>
!((model.GoodNum - (model.CaiGoodNum ?? 0) < 0)
// || (model.GoodNum - (model.CaiGoodNum ?? 0) == 0)
// || (model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0)))
// ||( model.NeedNums > 0 && model.HouseGoodNum > (model.GoodNum - (model.CaiGoodNum ?? 0)))
)
&& model.NeedNums <= 0 && model.CaiNums < (model.GoodNum - (model.CaiGoodNum ?? 0)));
//pOOrderList = pOOrderList.FindAll(model =>
// model.NeedNums <= 0 && model.CaiNums < (model.GoodNum - (model.CaiGoodNum ?? 0)));
}
//项目中该商品数量合计-采购退货合计<（销售退货合计-采购退货合计）×2 -不正常库存不为零（红色）
if (ddlFenXi.Text == "6")
{
pOOrderList = pOOrderList.FindAll(model =>
!((model.GoodNum - (model.CaiGoodNum ?? 0) < 0) ||
(model.GoodNum - (model.CaiGoodNum ?? 0) == 0) ||
model.NeedNums <= 0) &&
model.NeedNums > 0);
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList = jxcDetailSer.GetListArray_New_Out(pOOrderList);
//pOOrderList = pOOrderList.FindAll(model => model.NeedNums > 0);
}
//正常
if (ddlFenXi.Text == "7")
{
//pOOrderList = pOOrderList.FindAll(model => (model.GoodNum - (model.CaiGoodNum ?? 0) == 0)
// || (model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0))));
var pOOrderList1 = pOOrderList.FindAll(model => model.GoodNum - (model.CaiGoodNum ?? 0) == 0);
var pOOrderList2 = pOOrderList.FindAll(model => !((model.GoodNum - (model.CaiGoodNum ?? 0) < 0) || (model.GoodNum - (model.CaiGoodNum ?? 0) == 0)) &&
model.NeedNums <= 0 && model.CaiNums >= (model.GoodNum - (model.CaiGoodNum ?? 0)));
pOOrderList = pOOrderList.FindAll(model =>
!(
(model.GoodNum - (model.CaiGoodNum ?? 0) < 0) ||
(model.GoodNum - (model.CaiGoodNum ?? 0) == 0)
)
);
pOOrderList = pOOrderList.FindAll(model => model.NeedNums > 0);
//销售退货有有一次是库存为0 的 判断
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList = jxcDetailSer.GetListArray_New(pOOrderList);
pOOrderList.AddRange(pOOrderList1);
pOOrderList.AddRange(pOOrderList2);
}
//不正常
if (ddlFenXi.Text == "8")
{
var pOOrderList_1 = pOOrderList.FindAll(model => (model.GoodNum - (model.CaiGoodNum ?? 0) < 0) ||
(model.NeedNums <= 0 && model.CaiNums < (model.GoodNum - (model.CaiGoodNum ?? 0))));
pOOrderList = pOOrderList.FindAll(model =>
!((model.GoodNum - (model.CaiGoodNum ?? 0) < 0) ||
(model.GoodNum - (model.CaiGoodNum ?? 0) == 0) ||
model.NeedNums <= 0) &&
model.NeedNums > 0);
var jxcDetailSer = new Pro_JSXDetailInfoService();
pOOrderList = jxcDetailSer.GetListArray_New_Out(pOOrderList);
pOOrderList.AddRange(pOOrderList_1);
}
lblSellTuiTotal_Sum.Text = pOOrderList.Sum(t => t.GoodPriceSecond).ToString();
lblCaiTuiTotal_Sum.Text = pOOrderList.Sum(t => t.CAIGoodPriceTotal).ToString();
AspNetPager1.RecordCount = pOOrderList.Count;
this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
}
