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