public bool FormCheck()
{
if (this.txtBusCardDate.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写日期！');</script>");
this.txtBusCardDate.Focus();
return(false);
}
if (CommHelp.VerifesToDateTime(txtBusCardDate.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return(false);
}
if (this.txtBusCardTotal.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填金额！');</script>");
this.txtBusCardTotal.Focus();
return(false);
}
try
{
Convert.ToDecimal(txtBusCardTotal.Text);
}
catch (Exception)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写的数字格式有误！');</script>");
txtBusCardTotal.Focus();
return(false);
}
return(true);
}
private bool Check()
{
if (CommHelp.VerifesToNum(txtZhangQi.Text) == false || Convert.ToDecimal(txtZhangQi.Text) < 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目财务成本账期 格式有问题！');</script>");
return(false);
}
if (CommHelp.VerifesToNum(txtCeSuanDian.Text) == false || Convert.ToDecimal(txtCeSuanDian.Text) < 0 || Convert.ToDecimal(txtCeSuanDian.Text) > 1)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('财务成本测算点 格式有问题！');</script>");
return(false);
}
if (CommHelp.VerifesToNum(txtMonthLiLv.Text) == false || Convert.ToDecimal(txtMonthLiLv.Text) < 0 || Convert.ToDecimal(txtMonthLiLv.Text) > 1)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('财务成本月利率 格式有问题！');</script>");
return(false);
}
if (txtFrom.Text == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('考核前期日期 不能为空！');</script>");
return(false);
}
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('考核前期日期 格式错误！');</script>");
return(false);
}
}
return(true);
}
public bool FormCheck()
{
#region 设置自己要判断的信息
if (txtName.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写姓名！');</script>");
txtName.Focus();
return(false);
}
if (txtProName.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写项目名称！');</script>");
txtName.Focus();
return(false);
}
if (txtCreateTime.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写日期！');</script>");
txtCreateTime.Focus();
return(false);
}
if (CommHelp.VerifesToDateTime(txtCreateTime.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return(false);
}
//if (ddlPers.SelectedItem == null || ddlPers.Text == "")
//{
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择各户代表！');</script>");
// ddlPers.Focus();
// return false;
//}
if (ddlPers.Visible == true && ddlPers.SelectedItem == null)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择下一步审核人！');</script>");
ddlPers.Focus();
return(false);
}
if (DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text)) == null)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写申请用户不存在！');</script>");
txtName.Focus();
return(false);
}
#endregion
return(true);
}
private void ShowOil()
{
string sql = " 1=1 ";
if (txtOilFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtOilFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('加油日期 格式错误！');</script>");
return;
}
sql += string.Format(" and MaintenanceTime>='{0} 00:00:00'", txtOilFrom.Text);
}
if (txtOilTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtOilTo.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('加油日期 格式错误！');</script>");
return;
}
sql += string.Format(" and MaintenanceTime<='{0} 23:59:59'", txtOilTo.Text);
}
if (ddlOilCarNo.Text != "")
{
sql += string.Format(" and CardNo like '%{0}%'", ddlOilCarNo.Text);
}
if (txtFromChongZhi.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFromChongZhi.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('充值时间 格式错误！');</script>");
return;
}
sql += string.Format(" and ChongZhiDate>='{0} 00:00:00'", txtFromChongZhi.Text);
}
if (txtToChongZhi.Text != "")
{
if (CommHelp.VerifesToDateTime(txtToChongZhi.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('充值时间 格式错误！');</script>");
return;
}
sql += string.Format(" and ChongZhiDate<='{0} 23:59:59'", txtToChongZhi.Text);
}
List <TB_CarOilMaintenance> cars = this.CarOilSer.GetListArray(sql);
AspNetPager2.RecordCount = cars.Count;
this.gvOil.PageIndex = AspNetPager2.CurrentPageIndex - 1;
this.gvOil.DataSource = cars;
this.gvOil.DataBind();
}
//(NO.4)
public bool FormCheck()
{
#region 设置自己要判断的信息
if (txtDepartName.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写部门！');</script>");
txtDepartName.Focus();
return(false);
}
if (txtName.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写姓名！');</script>");
txtName.Focus();
return(false);
}
if (txtDateTime.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写日期！');</script>");
txtDateTime.Focus();
return(false);
}
else
{
if (CommHelp.VerifesToDateTime(txtDateTime.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('时间 格式错误！');</script>");
return(false);
}
}
if (txtToolName.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写工具名称！');</script>");
txtToolName.Focus();
return(false);
}
if (DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text)) == null)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写申请用户不存在！');</script>");
txtName.Focus();
return(false);
}
#endregion
if (ddlPers.Visible == true && ddlPers.SelectedItem == null)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择下一步审核人！');</script>");
ddlPers.Focus();
return(false);
}
return(true);
}
private void Show()
{
string where = "";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目时间 格式错误！');</script>");
return;
}
where += string.Format(" and CG_POOrder.PODate>='{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;
}
where += string.Format(" and CG_POOrder.PODate<='{0} 23:59:59'", txtTo.Text);
}
if (ddlCompany.Text == "-1" && ddlUser.Text != "-1")
{
where += string.Format(" and exists (select id from tb_User where ID={0} and CG_POOrder.appName=id)", ddlUser.Text);
}
if (ddlCompany.Text != "-1")
{
string where1 = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[0]);
if (ddlUser.Text != "-1")
{
where1 += string.Format(" and ID={0} ", ddlUser.Text);
}
where += string.Format(" and exists (select id from tb_User where {0} and CG_POOrder.appName=id)", where1);
}
if (ddlIsClose.Text != "-1")
{
where += " and IsClose=" + ddlIsClose.Text;
}
if (ddlJieIsSelected.Text != "-1")
{
where += " and JieIsSelected=" + ddlJieIsSelected.Text;
}
if (ddlSpecial.Text != "-1")
{
where += string.Format(" and CG_POOrder.IsSpecial={0}", ddlSpecial.Text);
}
ds = DBHelp.getDataSet(GetSql("").ToString());
noSellAndCaiGoodsList = new RuSellReportService().getHT(where);
resut_SellGoodsList = new Model.HashTableModel().HashTableToList(noSellAndCaiGoodsList);
resut_SellGoodsList.Sort();
dt_Fund = DBHelp.getDataTable(GetFundWrong());
GetSumPOTotal();
//dt_GetSumPOTotal = DBHelp.getDataTable();
}
private void Show()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and CreateTime>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and CreateTime<='{0} 23:59:59'", txtTo.Text);
}
if (txtProName.Text != "")
{
sql += string.Format(" and ProName like '%{0}%'", txtProName.Text);
}
if (txtProNo.Text != "")
{
sql += string.Format(" and ProNo like '%{0}%'", txtProNo.Text);
}
sql += " and UserId=" + Session["currentUserId"].ToString();
// sql += string.Format(@" and id in (select allE_id from tb_EForm where proId in (
//select pro_Id from A_ProInfo where pro_Type='工程材料审计清单') and state='通过')");
List <Tb_ProjectInvs> pos = this.proInvSer.GetListArray_Rep(sql);
decimal total = 0;
foreach (Tb_ProjectInvs model in pos)
{
total += model.Total == null?0:Convert.ToDecimal(model.Total);
}
lblTotal.Text = total.ToString();
this.gvList.DataSource = pos;
this.gvList.DataBind();
}
private void Show()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保养日期 格式错误！');</script>");
return;
}
sql += string.Format(" and MaintenanceTime>='{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 MaintenanceTime<='{0} 23:59:59'", txtTo.Text);
}
if (ddlCarNo.Text != "")
{
sql += string.Format(" and CardNo like '%{0}%'", ddlCarNo.Text);
}
sql += string.Format(@" and TB_CarMaintenance.id in (select allE_id from tb_EForm where proId in (
select pro_Id from A_ProInfo where pro_Type='车辆保养申请表') and state='通过')");
List <TB_CarMaintenance> cars = this.CarSer.GetListArray(sql);
decimal total = 0;
foreach (var model in cars)
{
if (model.Total != null)
{
total += Convert.ToDecimal(model.Total);
}
}
lbltotal.Text = total.ToString();
AspNetPager1.RecordCount = cars.Count;
this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = cars;
this.gvList.DataBind();
}
private void Show()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('违章时间 格式错误！');</script>");
return;
}
sql += string.Format(" and BreakTime>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('违章时间 格式错误！');</script>");
return;
}
sql += string.Format(" and BreakTime<='{0} 23:59:59'", txtTo.Text);
}
if (ddlCarNo.Text != "")
{
sql += string.Format(" and CarNo like '%{0}%'", ddlCarNo.Text);
}
if (txtDriver.Text != "")
{
sql += string.Format(" and Driver like '%{0}%'", txtDriver.Text);
}
if (ddlState.Text != "")
{
sql += string.Format(" and state like '%{0}%'", ddlState.Text);
}
List <TB_BreakRulesCar> cars = this.braRuleCarSer.GetListArray(sql);
AspNetPager1.RecordCount = cars.Count;
this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = cars;
this.gvList.DataBind();
}
private void select()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('时间 格式错误！');</script>");
return;
}
sql += string.Format(" and DisDate>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('时间 格式错误！');</script>");
return;
}
sql += string.Format(" and DisDate<='{0} 23:59:59'", txtTo.Text);
}
if (txtOutDispater.Text != "")
{
sql += string.Format(" and loginName like '%{0}%'", txtOutDispater.Text);
}
if (txtDispatcher.Text != "")
{
sql += string.Format(" and Dispatcher like '%{0}%'", txtDispatcher.Text);
}
if (txtSuiTong.Text != "")
{
sql += string.Format(" and SuiTongRen like '%{0}%'", txtSuiTong.Text);
}
List <DispatchingRep> users = this.DispatchingSer.GetListArrayReport(sql);
//AspNetPager1.RecordCount = users.Count;
//this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = users;
this.gvList.DataBind();
}
private bool Check()
{
if (!CommHelp.VerifesToDateTime(txtFrom.Text) || !CommHelp.VerifesToDateTime(txtTo.Text) ||
!CommHelp.VerifesToDateTime(txtpayableFrom.Text) || !CommHelp.VerifesToDateTime(txtpayableTo.Text))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('时间格式错误！');</script>");
return(false);
}
if (Convert.ToDateTime(txtFrom.Text) > Convert.ToDateTime(txtTo.Text))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票开始时间 必须小于等于 结束时间！');</script>");
return(false);
}
if (Convert.ToDateTime(txtpayableFrom.Text) > Convert.ToDateTime(txtpayableTo.Text))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票开始时间 必须小于 结束时间！');</script>");
return(false);
}
if (txtInvoiceDate.Text.Trim() == "" || txtpayableDate.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('运行时间不能为空！');</script>");
return(false);
}
if (CommHelp.VerifesToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " " + txtInvoiceDate.Text.Trim()) == false ||
CommHelp.VerifesToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " " + txtpayableDate.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('运行时间 格式错误！');</script>");
return(false);
}
if (string.IsNullOrEmpty(txtIP.Text))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('IP地址不能为空！');</script>");
return(false);
}
if (string.IsNullOrEmpty(txtUserId.Text))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('用户名不能为空！');</script>");
return(false);
}
if (string.IsNullOrEmpty(txtPwd.Text))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('密码不能为空！');</script>");
return(false);
}
return(true);
}
public bool FormCheck()
{
string strErr = "";
if (this.txtJDate.Text.Trim().Length == 0 || CommHelp.VerifesToDateTime(txtJDate.Text) == false)
{
strErr += "日期格式不正确！\\n";
}
if (strErr != "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr));
return(false);
}
return(true);
}
private void Show()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and DataTime>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and DataTime<='{0} 23:59:59'", txtTo.Text);
}
if (txtInvName.Text != "")
{
sql += string.Format(" and InvName like '%{0}%'", txtInvName.Text);
}
if (txtSeller.Text != "")
{
sql += string.Format(" and Seller like '%{0}%'", txtSeller.Text);
}
if (txtUnitName.Text != "")
{
sql += string.Format(" and UnitName like '%{0}%'", txtUnitName.Text);
}
sql += string.Format(" and CreateUser={0}", Session["currentUserId"].ToString());
List <TB_PO> pos = this.poSer.GetListArray(sql);
AspNetPager1.RecordCount = pos.Count;
this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = pos;
this.gvList.DataBind();
}
//===
private void ShowOld()
{
string sql = " 1=1 ";
if (txtOldDateFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtOldDateFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and Time>='{0} 00:00:00'", txtOldDateFrom.Text);
}
if (txtOldTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtOldTo.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and Time<='{0} 23:59:59'", txtOldTo.Text);
}
if (txtOldGuestName.Text.Trim() != "")
{
sql += string.Format(" and GuestName like '%{0}%'", txtOldGuestName.Text.Trim());
}
if (txtLoginName.Text != "")
{
sql += string.Format(" and tb_User.loginName like '%{0}%'", txtLoginName.Text);
}
List <TB_GuestTrack> GuestTracks = this.GuestTrackSer.GetListArrayOld(sql);
this.gvOld.DataSource = GuestTracks;
this.gvOld.DataBind();
}
private void select()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and DateTime>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and DateTime<='{0} 23:59:59'", txtTo.Text);
}
if (txtAppName.Text != "")
{
sql += string.Format(" and Name like '%{0}%'", txtAppName.Text);
}
if (txtUnit.Text != "")
{
sql += string.Format(" and ContactUnit like '%{0}%'", txtUnit.Text);
}
List <BusContactRep> users = this.busContactSer.GetListArrayReport(sql);
//AspNetPager1.RecordCount = users.Count;
//this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = users;
this.gvList.DataBind();
}
public bool FormCheck()
{
string strErr = "";
if (this.txtTeamLever.Text.Trim().Length == 0)
{
strErr += "姓名不能为空！\\n";
}
//if (this.txtCardNo.Text.Trim().Length == 0)
//{
// strErr += "身份证号不能为空！\\n";
//}
if (this.txtContractStartTime.Text.Trim().Length == 0)
{
strErr += "合作起始时间不能为空！\\n";
}
if (CommHelp.VerifesToDateTime(txtContractStartTime.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('合作起始时间 格式错误！');</script>");
return(false);
}
if (this.txtTeamPersonCount.Text.Trim().Length == 0)
{
strErr += "人员规模不能为空！\\n";
}
if (CommHelp.VerifesToNum(txtTeamPersonCount.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('人员规模 格式错误！');</script>");
return(false);
}
if (!string.IsNullOrEmpty(txtPhone.Text) && txtPhone.Text.Length != 11)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('手机号码 格式错误！');</script>");
return(false);
}
if (strErr != "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr));
return(false);
}
return(true);
}
private void Show()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('报价日期 格式错误！');</script>");
return;
}
sql += string.Format(" and QuoteDate>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('报价日期 格式错误！');</script>");
return;
}
sql += string.Format(" and QuoteDate<='{0} 23:59:59'", txtTo.Text);
}
if (txtQPNo.Text != "")
{
sql += string.Format(" and QuoteNo like '%{0}%'", txtQPNo.Text);
}
if (ddlGuestName.Text != "" && ddlGuestName.Text != "0")
{
sql += string.Format(" and GuestName='{0}'", ddlGuestName.SelectedValue);
}
List <tb_QuotePrice> pos = this.qpSer.GetListArray(sql);
AspNetPager1.RecordCount = pos.Count;
this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = pos;
this.gvList.DataBind();
}
public bool FormCheck()
{
if (this.txtTime.Text.Trim().Length == 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期不能为空！');</script>");
this.txtTime.Focus();
return(false);
}
if (CommHelp.VerifesToDateTime(txtTime.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return(false);
}
if (this.txtSupplierName.Text.Trim().Length == 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('供应商名称不能为空！');</script>");
this.txtSupplierName.Focus();
return(false);
}
if (this.txtSupplierSimpleName.Text.Trim().Length == 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('供应商简称不能为空！！');</script>");
this.txtSupplierSimpleName.Focus();
return(false);
}
if (this.txtLikeMan.Text.Trim().Length == 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('联系人不能为空！');</script>");
this.txtLikeMan.Focus();
return(false);
}
if (this.txtJob.Text.Trim().Length == 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('职务不能为空！');</script>");
this.txtJob.Focus();
return(false);
}
return(true);
}
protected void btnSelect_Click(object sender, EventArgs e)
{
if (txtFrom.Text == "" || txtTo.Text == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择日期！');</script>");
return;
}
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false || CommHelp.VerifesToDateTime(txtTo.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('订单时间 格式错误！');</script>");
return;
}
if (Convert.ToDateTime(txtFrom.Text) > Convert.ToDateTime(txtTo.Text))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期错误，请重新填写！');</script>");
return;
}
show();
}
private void Show()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and BusCardDate>='{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 BusCardDate<='{0} 23:59:59'", txtTo.Text);
}
if (ddlCardNo.Text != "")
{
sql += string.Format(" and BusCardNo like '%{0}%'", ddlCardNo.Text);
}
List <TB_BusCardRecord> pos = this.BusCardRecordSer.GetListArray(sql);
AspNetPager2.RecordCount = pos.Count;
this.gvCardRecordList.PageIndex = AspNetPager2.CurrentPageIndex - 1;
this.gvCardRecordList.DataSource = pos;
this.gvCardRecordList.DataBind();
}
private void Show()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('创建日期 格式错误！');</script>");
return;
}
sql += string.Format(" and CreateTime>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('创建日期 格式错误！');</script>");
return;
}
sql += string.Format(" and CreateTime<='{0} 23:59:59'", txtTo.Text);
}
if (txtGuestName.Text != "")
{
sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text);
}
List <tb_GusetInfo> pos = this.guestSer.GetListArray(sql);
AspNetPager1.RecordCount = pos.Count;
this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = pos;
this.gvList.DataBind();
}
public bool FormCheck()
{
string strErr = "";
if (this.txtPONo.Text.Trim().Length == 0)
{
strErr += "项目编号不能为空！\\n";
}
//if (this.txtGuestName.Text.Trim().Length == 0)
//{
// strErr += "客户名称不能为空！\\n";
//}
if (this.txtSalesUnit.Text.Trim().Length == 0)
{
strErr += "采购单位不能为空！\\n";
}
if (string.IsNullOrEmpty(txtName.Text))
{
strErr += "签呈单名称不能为空！\\n";
}
if (this.txtSummary.Text.Trim().Length == 0)
{
strErr += "签呈单摘要不能为空！\\n";
}
if (CommHelp.VerifesToNum(txtTotal.Text) == false)
{
strErr += "总金额格式错误！\\n";
}
if (CommHelp.VerifesToDateTime(txtSignDate.Text) == false)
{
strErr += "签订起始日期时间格式错误！\\n";
}
if (CommHelp.VerifesToNum(txtSumPages.Text) == false)
{
strErr += "签呈单总页数格式错误！\\n";
}
if (CommHelp.VerifesToNum(txtSumCount.Text) == false)
{
strErr += "签呈单总份数格式错误！\\n";
}
if (CommHelp.VerifesToNum(txtBCount.Text) == false)
{
strErr += "己方份数格式错误！\\n";
}
//if (cbIsRequire.Checked == false)
//{
// if (this.txtPONo.Text.Trim().Length == 0)
// {
// strErr += "项目编号不能为空！\\n";
// }
// if (this.txtAE.Text.Trim().Length == 0)
// {
// strErr += "AE不能为空！\\n";
// }
//}
if (strErr != "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", strErr));
return(false);
}
return(true);
}
private void Show()
{
if (ddlFKDF.Text != "-1" && !string.IsNullOrEmpty(txtFKDF.Text))
{
if (CommHelp.VerifesToNum(txtFKDF.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('反馈得分 格式错误！');</script>");
return;
}
}
if (ddlAllScore.Text != "-1" && !string.IsNullOrEmpty(txtAllScore.Text))
{
if (CommHelp.VerifesToNum(txtAllScore.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('综合得分 格式错误！');</script>");
return;
}
}
string sql = " ";
if (ddlCompany.Text != "-1")
{
string where = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[2]);
sql += string.Format(" and exists (select id from tb_User where IFZhui=0 and {0} and CG_POOrder.appName=id)", where);
}
if (txtPONo.Text != "")
{
sql += string.Format(" and CG_POOrder.PONo like '%{0}%'", txtPONo.Text);
}
if (ttxPOName.Text != "")
{
sql += string.Format(" and CG_POOrder.POName like '%{0}%'", ttxPOName.Text);
}
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目时间 格式错误！');</script>");
return;
}
sql += string.Format(" and CG_POOrder.PODate>='{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 CG_POOrder.PODate<='{0} 23:59:59'", txtTo.Text);
}
if (txtGuestName.Text != "")
{
sql += string.Format(" and CG_POOrder.GuestName like '%{0}%'", txtGuestName.Text);
}
var isColse = "";
if (ddlIsClose.Text != "-1")
{
isColse = " and IsClose=" + ddlIsClose.Text;
}
if (ddlIsSelect.Text != "-1")
{
isColse += " and IsSelected=" + ddlIsSelect.Text;
}
if (ddlPOTyle.Text != "-1")
{
isColse += " and CG_POOrder.POType=" + ddlPOTyle.Text;
}
if (ddlModel.Text != "全部")
{
sql += string.Format(" and Model='{0}'", ddlModel.Text);
}
if (ddlJieIsSelected.Text != "-1")
{
isColse += " and JieIsSelected=" + ddlJieIsSelected.Text;
}
//if (ViewState["showAll"] != null)
//{
// sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO )", Session["currentUserId"]);
//}
//if (ddlGuestTypeList.SelectedValue != "全部")
//{
// sql += string.Format(" and EXISTS (select id from TB_GuestTrack where MyGuestType='{0}' and TB_GuestTrack.id=CG_POOrder.GuestId )",ddlGuestTypeList.SelectedValue);
//}
if (ddlGuestTypeList.SelectedValue != "全部")
{
sql += string.Format(" and GuestType='{0}'", ddlGuestTypeList.SelectedValue);
}
if (ddlGuestProList.SelectedValue != "-2")
{
sql += string.Format(" and GuestPro={0}", ddlGuestProList.SelectedValue);
}
if (ddlUser.Text == "-1")//显示所有用户
{
if (ddlIsSpecial.Text != "-1")
{
sql += string.Format(" and IsSpecial={1} {0} ", isColse, ddlIsSpecial.Text);
//sql += string.Format(" and EXISTS (select ID from CG_POOrder where IsSpecial=0 AND PONO=JXC_REPORT.PONO {0})", isColse);
}
//else
//{
// sql += string.Format(" and EXISTS (select ID from CG_POOrder where IsSpecial=1 AND PONO=JXC_REPORT.PONO {0})", isColse);
//}
//var model = Session["userInfo"] as User;
//sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职') AND PONO=JXC_REPORT.PONO )", Session["currentUserId"]);
}
else if (ddlUser.Text == "0")//显示部门信息
{
var model = Session["userInfo"] as User;
//sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') AND PONO=JXC_REPORT.PONO )", model.LoginIPosition);
if (ddlIsSpecial.Text != "-1")
{
sql += string.Format(" and CG_POOrder.AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') and IsSpecial={2} {1}",
model.LoginIPosition, isColse, ddlIsSpecial.Text);
// sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') AND PONO=JXC_REPORT.PONO and IsSpecial=0 {1})", model.LoginIPosition, isColse);
}
else
{
sql += string.Format(" and CG_POOrder.AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') {1}",
model.LoginIPosition, isColse);
//sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') AND PONO=JXC_REPORT.PONO and IsSpecial=1 {1})", model.LoginIPosition, isColse);
}
}
else
{
if (ddlIsSpecial.Text != "-1")
{
sql += string.Format(" and CG_POOrder.AppName={0} and IsSpecial={2} {1} ", ddlUser.Text, isColse, ddlIsSpecial.Text);
//sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO and IsSpecial=0 {1})", ddlUser.Text, isColse);
}
else
{
sql += string.Format(" and CG_POOrder.AppName={0} {1} ", ddlUser.Text, isColse);
//sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO and IsSpecial=1 {1})", ddlUser.Text, isColse);
}
//sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO )", ddlUser.Text);
}
if (CheckBox1.Checked || CheckBox2.Checked || CheckBox3.Checked || CheckBox4.Checked)
{
sql += " and exists ( select ID from CG_POOrder where PONO=JXC_REPORT.PONO";
if (CheckBox1.Checked)
{
sql += string.Format(" and POStatue='{0}'", CheckBox1.Text);
}
if (CheckBox2.Checked)
{
sql += string.Format(" and POStatue2='{0}'", CheckBox2.Text);
}
if (CheckBox3.Checked)
{
sql += string.Format(" and POStatue3='{0}'", CheckBox3.Text);
}
if (CheckBox4.Checked)
{
sql += string.Format(" and POStatue4='{0}'", CheckBox4.Text);
}
sql += ")";
}
string having = " having ";
if (CheckBox5.Checked && CheckBox6.Checked)
{
having += string.Format(" (avg(SellFPTotal)<> sum(goodSellTotal) or avg(SellFPTotal) is null) and (avg(InvoTotal)<> sum(goodSellTotal) or sum(InvoTotal) is null)");
}
else if (CheckBox5.Checked || CheckBox6.Checked)
{
if (CheckBox5.Checked)
{
having += string.Format(" avg(SellFPTotal)<> sum(goodSellTotal) or avg(SellFPTotal) is null ");
}
if (CheckBox6.Checked)
{
having += string.Format(" avg(InvoTotal)<> sum(goodSellTotal) or sum(InvoTotal) is null ");
}
}
else
{
having = "";
}
string fuhao = " where 1=1 ";
if (ddlFKDF.Text != "-1" && !string.IsNullOrEmpty(txtFKDF.Text))
{
fuhao += string.Format(" and MyValue{0}{1}", ddlFKDF.Text, txtFKDF.Text);
}
if (ddlFuHao.Text != "-1")
{
fuhao = string.Format(" where SumPOTotal {0} isnull(goodSellTotal,0)", ddlFuHao.Text);
}
if (ddlPOFaTotal.Text != "-1")
{
fuhao += string.Format(" and SumPOTotal {0} isnull(SellFPTotal,0)", ddlPOFaTotal.Text);
}
if (ddlShiJiDaoKuan.Text != "-1")
{
fuhao += string.Format(" and SumPOTotal {0} isnull(InvoTotal,0)", ddlShiJiDaoKuan.Text);
}
if (ddlEquPOTotal.Text != "-1")
{
if (CommHelp.VerifesToNum(txtEquTotal.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目金额 格式错误！');</script>");
return;
}
fuhao += string.Format(" and SumPOTotal{0}{1}", ddlEquPOTotal.Text, txtEquTotal.Text);
}
if (ddlJingLiTotal.Text != "-1")
{
fuhao += string.Format(" and maoliTotal {0} (isnull(InvoTotal,0)-isnull(goodTotal,0))", ddlJingLiTotal.Text);
}
if (!string.IsNullOrEmpty(txtProProfit.Text) && ddlProProfit.Text != "-1")
{
if (CommHelp.VerifesToNum(txtProProfit.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目净利 格式错误！');</script>");
return;
}
fuhao += string.Format(" and maoliTotal {0} {1}", ddlProProfit.Text, txtProProfit.Text);
}
if (!string.IsNullOrEmpty(txtProTureProfit.Text) && ddlProTureProfit.Text != "-1")
{
if (CommHelp.VerifesToNum(txtProTureProfit.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('实际净利 格式错误！');</script>");
return;
}
fuhao += string.Format(" and InvoTotal-goodTotal {0} {1}", ddlProTureProfit.Text, txtProTureProfit.Text);
}
if (ddlPaiGong.Text != "-1")
{
//fuhao += string.Format(" and OutDispater={0}", ddlPaiGong.Text);
if (ddlPaiGong.Text != "-1000")
{
fuhao += string.Format(" and OutDispater={0}", ddlPaiGong.Text);
}
else
{
string userIds = "";
foreach (ListItem item in ddlPaiGong.Items)
{
if (item.Value != "-1" && item.Value != "-1000")
{
userIds += string.Format("{0},", item.Value);
}
}
fuhao += string.Format(" and OutDispater not in ({0})", userIds.Trim(','));
}
}
if (txtPGFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtPGFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('派工时间 格式错误！');</script>");
return;
}
fuhao += string.Format(" and DisDate>='{0} 00:00:00'", txtPGFrom.Text);
}
if (txtPGTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtPGTo.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('派工时间 格式错误！');</script>");
return;
}
fuhao += string.Format(" and DisDate<='{0} 23:59:59'", txtPGTo.Text);
}
if (ddlJingLi.Text != "-1" && !string.IsNullOrEmpty(txtJingLi.Text))
{
if (CommHelp.VerifesToNum(txtJingLi.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('净利润率 格式错误！');</script>");
return;
}
}
List <JXC_REPORTTotal> pOOrderList = this.POSer.GetSkill_Total(sql, having, fuhao);
if (ddlTrueZhangQI.Text != "-1")
{
if (ddlTrueZhangQI.Text == "1")
{
pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi <= 30);
}
if (ddlTrueZhangQI.Text == "2")
{
pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi > 30 && T.trueZhangQi <= 60);
}
if (ddlTrueZhangQI.Text == "3")
{
pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi > 60 && T.trueZhangQi <= 90);
}
if (ddlTrueZhangQI.Text == "4")
{
pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi > 90 && T.trueZhangQi <= 120);
}
if (ddlTrueZhangQI.Text == "5")
{
pOOrderList = pOOrderList.FindAll(T => T.trueZhangQi > 120);
}
}
if (ddlJingLi.Text != "-1" && !string.IsNullOrEmpty(txtJingLi.Text))
{
decimal jingLi = Convert.ToDecimal(txtJingLi.Text);
if (ddlJingLi.Text == ">")
{
pOOrderList = pOOrderList.FindAll(t => t.JingLi > jingLi);
}
if (ddlJingLi.Text == "<")
{
pOOrderList = pOOrderList.FindAll(t => t.JingLi < jingLi);
}
if (ddlJingLi.Text == ">=")
{
pOOrderList = pOOrderList.FindAll(t => t.JingLi >= jingLi);
}
if (ddlJingLi.Text == "<=")
{
pOOrderList = pOOrderList.FindAll(t => t.JingLi <= jingLi);
}
if (ddlJingLi.Text == "=")
{
pOOrderList = pOOrderList.FindAll(t => t.JingLi == jingLi);
}
}
if (ddlAllScore.Text != "-1" && !string.IsNullOrEmpty(txtAllScore.Text))
{
if (CommHelp.VerifesToNum(txtAllScore.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('综合得分 格式错误！');</script>");
return;
}
fuhao = ddlAllScore.Text;
decimal allScore = Convert.ToDecimal(txtAllScore.Text);
if (fuhao == ">")
{
pOOrderList = pOOrderList.FindAll(t => t.allScore > allScore);
}
if (fuhao == "<")
{
pOOrderList = pOOrderList.FindAll(t => t.allScore < allScore);
}
if (fuhao == ">=")
{
pOOrderList = pOOrderList.FindAll(t => t.allScore >= allScore);
}
if (fuhao == "<=")
{
pOOrderList = pOOrderList.FindAll(t => t.allScore <= allScore);
}
if (fuhao == "=")
{
pOOrderList = pOOrderList.FindAll(t => t.allScore == allScore);
}
if (fuhao == "<>")
{
pOOrderList = pOOrderList.FindAll(t => t.allScore == allScore);
}
}
//var getAllPONos = pOOrderList.Aggregate("", (current, m) => current + ("'" + m.PONo + "',")).Trim(',');
//lblVisAllPONO.Text = getAllPONos;
Hashtable ht = new Hashtable();
decimal jlr = 0;
decimal sumgoodSellTotal = 0;
decimal sumTrueLiRun = 0;
decimal sumSellFPTotal = 0;
decimal sumSumPOTotal = 0;
decimal sumInvoiceTotal = 0;
foreach (var m in pOOrderList)
{
if (!ht.ContainsKey(m.PONo))
{
jlr += m.maoliTotal;
sumgoodSellTotal += m.goodSellTotal;
sumTrueLiRun += m.TrueLiRun;
sumSellFPTotal += m.SellFPTotal;
sumSumPOTotal += m.SumPOTotal;
sumInvoiceTotal += m.InvoiceTotal;
ht.Add(m.PONo, null);
}
}
lblJLR.Text = string.Format("{0:n6}", jlr);
lblXSE.Text = string.Format("{0:n6}", sumgoodSellTotal);
var trueLiRun = sumTrueLiRun;
lblSJLR.Text = string.Format("{0:n6}", trueLiRun);
lblFP.Text = string.Format("{0:n6}", sumSellFPTotal);
// 项目总额：XXX
decimal allPoTotal = sumSumPOTotal;
lblAllPoTotal.Text = string.Format("{0:n6}", allPoTotal);
//项目总利润率：YYY = 项目净利合计/XXX
lblAllLRLv.Text = "0";
if (allPoTotal > 0)
{
lblAllLRLv.Text = string.Format("{0:f2}", (jlr / allPoTotal * 100));
}
// 实际总利润率：ZZZ= 实际利润合计/XXX
lblAllTrunLv.Text = "0";
if (allPoTotal > 0)
{
lblAllTrunLv.Text = string.Format("{0:f2}", (trueLiRun / allPoTotal * 100));
}
//项目到款总额：TTT= 实到帐的合计
var allDaoKuan = sumInvoiceTotal;
lblAllDaoKuan.Text = string.Format("{0:n6}", allDaoKuan);
//到款率： VVV=TTT/XXX
lblAllDaoKuanLv.Text = "0";
if (allPoTotal > 0)
{
lblAllDaoKuanLv.Text = string.Format("{0:f2}", (allDaoKuan / allPoTotal * 100));
}
//开票率：LLL= 发票总额合计 /XXX
var faPiaoTotal = sumSellFPTotal;// pOOrderList.Sum(t => t.SellFPTotal);
lblAllFaPiaoLv.Text = "0";
if (allPoTotal > 0)
{
lblAllFaPiaoLv.Text = string.Format("{0:f2}", (faPiaoTotal / allPoTotal * 100));
}
var sumAllScore = pOOrderList.Sum(t => t.allScore);
var sumMyValue = pOOrderList.Sum(t => t.MyValue);
var count = pOOrderList.Count(t => t.DisDate != null);
lblAllScore.Text = string.Format("{0:f2}", sumAllScore);
lblFanKuiScore.Text = string.Format("{0:f2}", sumMyValue);
if (count == 0)
{
lblAvgScore.Text = string.Format("{0:f2}", 0);
lblAvgFKscore.Text = string.Format("{0:f2}", 0);
}
else
{
lblAvgScore.Text = string.Format("{0:f2}", sumAllScore / count);
lblAvgFKscore.Text = string.Format("{0:f2}", sumMyValue / count);
}
AspNetPager1.RecordCount = pOOrderList.Count;
this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
//pager.TotalCount = pOOrderList.Count;
//PagerControl page= gvMain.BottomPagerRow.Cells[0].FindControl("myPage") as PagerControl;
//page.TotalCount = pOOrderList.Count;
//page.BindData();
// AspNetPager1.CustomInfoHTML = "第<font color='red'><b>%currentPageIndex%</b></font>页，共%PageCount%页，每页显示%PageSize%条记录";
}
private void Show(bool isPrint = false)
{
string sql = " 1=1 ";
if (txtBusFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtBusFPNO.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('公交费发票号码 格式错误！');</script>");
return;
}
if (txtRepastFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtRepastFPNO.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('餐饮发票号码 格式错误！');</script>");
return;
}
if (txtHotelFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtHotelFPNO.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('住宿发票号码 格式错误！');</script>");
return;
}
if (txtOilFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtOilFPNO.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('汽油发票号码 格式错误！');</script>");
return;
}
if (txtGuoBeginFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtGuoBeginFPNO.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('过路费发票号码 格式错误！');</script>");
return;
}
if (txtPostFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtPostFPNO.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('邮寄发票号码 格式错误！');</script>");
return;
}
if (txtOtherFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtOtherFPNO.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('其它费用发票号码 格式错误！');</script>");
return;
}
if (txtCaiFPNO.Text.Trim() != "" && CommHelp.VerifesToNum_NoString(txtCaiFPNO.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('小额采购发票号码 格式错误！');</script>");
return;
}
if (txtBusFPNO.Text.Trim() != "")
{
sql += string.Format(" and BusFPNO like '%{0}%'", txtBusFPNO.Text.Trim());
}
if (txtRepastFPNO.Text.Trim() != "")
{
sql += string.Format(" and RepastFPNO like '%{0}%'", txtRepastFPNO.Text.Trim());
}
if (txtHotelFPNO.Text.Trim() != "")
{
sql += string.Format(" and HotelFPNO like '%{0}%'", txtHotelFPNO.Text.Trim());
}
if (txtOilFPNO.Text.Trim() != "")
{
sql += string.Format(" and OilFPNO like '%{0}%'", txtOilFPNO.Text);
}
if (txtGuoBeginFPNO.Text.Trim() != "")
{
sql += string.Format(" and GuoBeginFPNO like '%{0}%'", txtGuoBeginFPNO.Text.Trim());
}
if (txtPostFPNO.Text.Trim() != "")
{
sql += string.Format(" and PostFPNO like '%{0}%'", txtPostFPNO.Text.Trim());
}
if (txtOtherFPNO.Text.Trim() != "")
{
sql += string.Format(" and OtherFPNO like '%{0}%'", txtOtherFPNO.Text.Trim());
}
if (txtCaiFPNO.Text.Trim() != "")
{
sql += string.Format(" and CaiFPNO like '%{0}%'", txtCaiFPNO.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 Tb_DispatchList.CreateTime>='{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 Tb_DispatchList.CreateTime<='{0} 23:59:59'", txtTo.Text);
}
if (txtGuestName.Text.Trim() != "")
{
sql += string.Format(" and Tb_DispatchList.GuestName like '%{0}%'", txtGuestName.Text.Trim());
}
if (txtPOName.Text.Trim() != "")
{
sql += string.Format(" and Tb_DispatchList.POName like '%{0}%'", txtPOName.Text.Trim());
}
if (txtPONO.Text.Trim() != "")
{
if (CheckPoNO(txtPONO.Text) == false)
{
return;
}
sql += string.Format(" and Tb_DispatchList.PONo like '%{0}%'", txtPONO.Text.Trim());
}
if (ddlFuHao.Text != "-1" && !string.IsNullOrEmpty(txtTotal.Text))
{
if (CommHelp.VerifesToNum(txtTotal.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('报销金额 格式错误！');</script>");
return;
}
sql += string.Format(" and ISNULL(BusTotal,0)+ISNULL(RepastTotal,0)+ISNULL(HotelTotal,0)+ISNULL(OilTotal,0)+ISNULL(GuoTotal,0)+ISNULL(PostTotal,0)+ISNULL(Tb_DispatchList.PoTotal,0)+ISNULL(OtherTotal,0) {0}{1}", ddlFuHao.Text, txtTotal.Text);
}
if (txtProNo.Text.Trim() != "")
{
if (CheckProNo(txtProNo.Text) == false)
{
return;
}
sql += string.Format(" and Tb_DispatchList.CardNo like '%{0}%'", txtProNo.Text.Trim());
}
if (ddlFundType.Text != "-1")
{
if (ddlFundType.Text == "0")//公交费
{
sql += string.Format(" and BusTotal is not null and BusTotal>0", ddlFundType.Text);
}
else if (ddlFundType.Text == "1")//餐饮费
{
sql += string.Format(" and RepastTotal is not null and RepastTotal>0", ddlFundType.Text);
}
else if (ddlFundType.Text == "2")//住宿费
{
sql += string.Format(" and HotelTotal is not null and HotelTotal>0", ddlFundType.Text);
}
else if (ddlFundType.Text == "3")//汽油补贴
{
sql += string.Format(" and OilTotal is not null and OilTotal>0", ddlFundType.Text);
}
else if (ddlFundType.Text == "4")//过路费
{
sql += string.Format(" and GuoTotal is not null and GuoTotal>0", ddlFundType.Text);
}
else if (ddlFundType.Text == "5")//邮寄费
{
sql += string.Format(" and PostTotal is not null and PostTotal>0", ddlFundType.Text);
}
else if (ddlFundType.Text == "6")//小额采购
{
sql += string.Format(" and Tb_DispatchList.PoTotal is not null and Tb_DispatchList.PoTotal>0", ddlFundType.Text);
}
else if (ddlFundType.Text == "7")//其他费用
{
sql += string.Format(" and OtherTotal is not null and OtherTotal>0", ddlFundType.Text);
}
}
if (ddlCompany.Text != "-1")
{
sql += string.Format(" and TB_Company.ComCode='{0}'", ddlCompany.Text.Split(',')[2]);
}
if (ddlUser.Text != "-1")
{
sql += string.Format(" and AE='{0}'", ddlUser.SelectedItem.Text);
}
if (ddlState.Text != "全部")
{
sql += string.Format(" and Tb_DispatchList.state='{0}'", ddlState.Text);
}
if (!string.IsNullOrEmpty(txtKeyWords.Text))
{
sql += string.Format(@" and ([BusFromAddress] like '%{0}%'
or [BusFromAddress] like '%{0}%' or [BusToAddress] like '%{0}%' or CONVERT(varchar(100), BusFromTime, 120) like '%{0}%' or CONVERT(varchar(100), BusToTime, 120) like '%{0}%'
or [RepastAddress] like '%{0}%' or [RepastTotal] like '%{0}%' or [RepastPerNum] like '%{0}%' or [RepastPers] like '%{0}%'
or [HotelAddress] like '%{0}%' or [HotelName] like '%{0}%' or [OilFromAddress] like '%{0}%' or [OilToAddress] like '%{0}%'
or [OilLiCheng] like '%{0}%' or [GuoBeginAddress] like '%{0}%' or [GuoToAddress] like '%{0}%' or [PostFromAddress] like '%{0}%'
or [PostToAddress] like '%{0}%' or [PoContext] like '%{0}%' or [OtherContext] like '%{0}%' or [BusRemark] like '%{0}%'
or [RepastRemark] like '%{0}%' or [HotelRemark] like '%{0}%' or [OilRemark] like '%{0}%' or [GuoRemark] like '%{0}%'
or [PostRemark] like '%{0}%' or Tb_DispatchList.[PoRemark] like '%{0}%' or [OtherRemark] like '%{0}%' or [PostNo] like '%{0}%'
or [PostCompany] like '%{0}%' or [PostContext] like '%{0}%' or [PostToPer] like '%{0}%' or [Post_No] like '%{0}%')", txtKeyWords.Text);
}
if (ddlModel.Text != "全部")
{
sql += string.Format(" and Model='{0}'", ddlModel.Text);
}
//增加查询条件
if (ddlGuestTypeList.SelectedValue != "全部")
{
sql += string.Format(" and GuestType='{0}'", ddlGuestTypeList.SelectedValue);
}
if (ddlGuestProList.SelectedValue != "-2")
{
sql += string.Format(" and GuestPro={0}", ddlGuestProList.SelectedValue);
}
if (ddlClose.Text != "-1")
{
sql += string.Format(" and CG_POOrder.IsClose={0} ", ddlClose.Text);
}
if (ddlIsSelect.Text != "-1")
{
sql += string.Format(" and CG_POOrder.IsSelected={0} ", ddlIsSelect.Text);
}
if (ddlJieIsSelected.Text != "-1")
{
sql += string.Format(" and CG_POOrder.JieIsSelected={0} ", ddlJieIsSelected.Text);
}
if (ddlIsSpecial.Text != "-1")
{
sql += string.Format(" and CG_POOrder.IsSpecial={0} ", ddlIsSpecial.Text);
}
if (!string.IsNullOrEmpty(txtPOSTNO.Text.Trim()))
{
sql += string.Format(" and PostNo LIKE '%{0}%' ", txtPOSTNO.Text.Trim());
}
List <Tb_DispatchList> dispatchList = this.dispatchSer.GetListArrayReport(sql);
if (isPrint)
{
Tb_DispatchList sumTotal = new Tb_DispatchList();
sumTotal.Total = dispatchList.Sum(t => t.Total);
dispatchList.Add(sumTotal);
}
lblTotal.Text = dispatchList.Sum(t => t.Total).ToString();
AspNetPager1.RecordCount = dispatchList.Count;
this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = dispatchList;
this.gvList.DataBind();
}
public bool FormCheck()
{
#region 设置自己要判断的信息
if (txtRuTime.Text == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写出库日期！');</script>");
txtRuTime.Focus();
return(false);
}
else
{
if (CommHelp.VerifesToDateTime(txtRuTime.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('出库日期 格式错误！');</script>");
return(false);
}
}
if (string.IsNullOrEmpty(txtSellProNo.Text))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你选择出库单号！');</script>");
txtSellProNo.Focus();
return(false);
}
try
{
Convert.ToDateTime(txtRuTime.Text);
}
catch (Exception)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写出库日期格式有误！');</script>");
txtRuTime.Focus();
return(false);
}
if (ddlPers.Visible == true && ddlPers.SelectedItem == null)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择下一步审核人！');</script>");
ddlPers.Focus();
return(false);
}
if (DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text)) == null)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写申请用户不存在！');</script>");
return(false);
}
//if (DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text)) == null)
//{
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写检验人不存在！');</script>");
// return false;
//}
#endregion
if (rdoA.Checked == false && rdoB.Checked == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择签收状态！');</script>");
return(false);
}
if (Request["allE_id"] == null)
{
//List<Sell_OrderOutHouseBacks> POOrders = Session["Orders"] as List<Sell_OrderOutHouseBacks>;
//if (POOrders == null || POOrders.Count <= 0)
//{
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请添加明显信息！');</script>");
// return false;
//}
//if (POOrders.Count == 0)
//{
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择销售商品！');</script>");
// return false;
//}
}
else
{
}
return(true);
}
private void Show()
{
string sql = " 1=1 ";
if (ddlCompany.Text != "全部")
{
sql += string.Format(" and tb_QuotePrice.ComName='{0}'", ddlCompany.SelectedItem.Text);
}
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('日期 格式错误！');</script>");
return;
}
sql += string.Format(" and QuoteDate>='{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 QuoteDate<='{0} 23:59:59'", txtTo.Text);
}
if (txtProno.Text != "")
{
sql += string.Format(" and QuoteNo like '%{0}%'", txtProno.Text);
}
if (txtGuestName.Text.Trim() != "")
{
sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text.Trim());
}
if (!string.IsNullOrEmpty(txtLinkMan.Text))
{
sql += string.Format(" and ContactPerToInv like '%{0}%'", txtLinkMan.Text);
}
if (!string.IsNullOrEmpty(txtGuestAddress.Text))
{
sql += string.Format(" and AddressToInv like '%{0}%'", txtGuestAddress.Text);
}
if (!string.IsNullOrEmpty(txtZhaiYao.Text))
{
sql += string.Format(" and Remark like '%{0}%'", txtZhaiYao.Text);
}
if (!string.IsNullOrEmpty(txtGoodName.Text) || !string.IsNullOrEmpty(txtModel.Text) || !string.IsNullOrEmpty(txtGoodBrand.Text))
{
sql += string.Format(" and exists ( select tb_QuotePrice_InvDetails.id from tb_QuotePrice_InvDetails where 1=1 ");
if (!string.IsNullOrEmpty(txtGoodName.Text))
{
sql += string.Format(" and InvName like '%{0}%'", txtGoodName.Text);
}
if (!string.IsNullOrEmpty(txtModel.Text))
{
sql += string.Format(" and InvModel like '%{0}%'", txtModel.Text);
}
if (!string.IsNullOrEmpty(txtGoodBrand.Text))
{
sql += string.Format(" and InvBrand like '%{0}%'", txtGoodBrand.Text);
}
sql += " and tb_QuotePrice_InvDetails.QuoteId=tb_QuotePrice.Id)";
}
if (ddlUser.Text == "-1")//显示所有用户
{
}
else if (ddlUser.Text == "0")//显示部门信息
{
var model = Session["userInfo"] as User;
sql += string.Format(" and CreateUser in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') ",
model.LoginIPosition);
}
else
{
sql += string.Format(" and CreateUser={0} ", ddlUser.Text);
}
if (ddlType.Text != "-1")
{
sql += string.Format(" and QPType={0}", ddlType.Text);
}
List <tb_QuotePrice> pos = this.qpSer.GetListArray(sql);
AspNetPager1.RecordCount = pos.Count;
this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = pos;
this.gvList.DataBind();
}
private void Show()
{
string sql = " 1=1 ";
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发生时间 格式错误！');</script>");
return;
}
sql += string.Format(" and EvTime>='{0} 00:00:00'", txtFrom.Text);
}
if (txtTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtTo.Text.Trim()) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发生时间 格式错误！');</script>");
return;
}
sql += string.Format(" and EvTime<='{0} 23:59:59'", txtTo.Text);
}
if (txtNo.Text.Trim() != "")
{
if (CheckProNo(txtNo.Text) == false)
{
return;
}
sql += string.Format(" and CardNo like '%{0}%'", txtNo.Text.Trim());
}
sql += string.Format(" and (UserId={0} or exists(select id from CG_POOrder where CG_POOrder.PONo=Tb_DispatchList.PONo and IFZhui=0 and AE='{1}'))", Session["currentUserId"], Session["LoginName"].ToString());
sql += string.Format(@" and Tb_DispatchList.id in (select allE_id from tb_EForm where proId in (
select pro_Id from A_ProInfo where pro_Type in ('预期报销单(油费报销)','预期报销单')) and state='通过')");
//List<Tb_DispatchList> dispaths = this.dispathSer.GetListArray(sql);
//decimal total = 0;
//foreach (Tb_DispatchList model in dispaths)
//{
// total += model.Total;
//}
string type = ddlType.Text;
if (type == "")
{
gvList.Attributes.Add("Width", "300%");
gvList.Width = Unit.Parse("300%");
for (int i = 4; i <= 48; i++)
{
gvList.Columns[i].Visible = true;
}
}
else
{
gvList.Attributes.Add("Width", "100%");
gvList.Width = Unit.Parse("100%");
for (int i = 4; i <= 48; i++)
{
gvList.Columns[i].Visible = false;
}
if (type == "公交费")
{
for (int i = 4; i <= 11; i++)
{
gvList.Columns[i].Visible = true;
}
sql += string.Format(" and BusTotal is not null");
}
else if (type == "餐饮费")
{
for (int i = 12; i <= 17; i++)
{
gvList.Columns[i].Visible = true;
}
sql += string.Format(" and RepastTotal is not null");
}
else if (type == "住宿费")
{
for (int i = 18; i <= 22; i++)
{
gvList.Columns[i].Visible = true;
}
sql += string.Format(" and HotelTotal is not null");
}
else if (type == "汽油补贴")
{
for (int i = 23; i <= 27; i++)
{
gvList.Columns[i].Visible = true;
}
sql += string.Format(" and OilTotal is not null");
}
else if (type == "过路费")
{
for (int i = 28; i <= 31; i++)
{
gvList.Columns[i].Visible = true;
}
sql += string.Format(" and GuoTotal is not null");
}
else if (type == "邮寄费")
{
for (int i = 32; i <= 41; i++)
{
gvList.Columns[i].Visible = true;
}
sql += string.Format(" and PostTotal is not null");
}
else if (type == "小额采购")
{
for (int i = 42; i <= 44; i++)
{
gvList.Columns[i].Visible = true;
}
sql += string.Format(" and PoTotal is not null");
}
else if (type == "其它费用")
{
for (int i = 45; i <= 48; i++)
{
gvList.Columns[i].Visible = true;
}
sql += string.Format(" and OtherTotal is not null");
}
}
List <Tb_DispatchList> dispaths = this.dispathSer.GetListArray(sql);
decimal total = 0;
if (type == "")
{
foreach (Tb_DispatchList model in dispaths)
{
total += model.Total;
}
}
else if (type == "公交费")
{
foreach (Tb_DispatchList model in dispaths)
{
total += model.BusTotal.Value;
}
}
else if (type == "餐饮费")
{
foreach (Tb_DispatchList model in dispaths)
{
total += model.RepastTotal.Value;
}
}
else if (type == "住宿费")
{
foreach (Tb_DispatchList model in dispaths)
{
total += model.HotelTotal.Value;
}
}
else if (type == "汽油补贴")
{
foreach (Tb_DispatchList model in dispaths)
{
total += model.OilTotal.Value;
}
}
else if (type == "过路费")
{
foreach (Tb_DispatchList model in dispaths)
{
total += model.GuoTotal.Value;
}
}
else if (type == "邮寄费")
{
foreach (Tb_DispatchList model in dispaths)
{
total += model.PostTotal.Value;
}
}
else if (type == "小额采购")
{
foreach (Tb_DispatchList model in dispaths)
{
total += model.PoTotal.Value;
}
}
else if (type == "其它费用")
{
foreach (Tb_DispatchList model in dispaths)
{
total += model.OtherTotal.Value;
}
}
lblTotal.Text = total.ToString();
AspNetPager1.RecordCount = dispaths.Count;
this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvList.DataSource = dispaths;
this.gvList.DataBind();
}
private void Show()
{
if (ddlFPType.Items.Count >= 2)
{
ddlFPType.Items[ddlFPType.Items.Count - 2].Attributes.Add("style", "background-color: red");
}
string sql = " 1=1 ";
if (txtPONo.Text.Trim() != "")
{
if (CheckPoNO(txtPONo.Text.Trim()) == false)
{
return;
}
sql += string.Format(" and Sell_OrderFP.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 (ddlStatue.Text != "")
{
sql += string.Format(" and Status='{0}'", ddlStatue.Text);
}
else
{
sql += string.Format(" and Status<>'不通过'");
}
if (txtProNo.Text.Trim() != "")
{
if (CheckProNo(txtProNo.Text.Trim()) == false)
{
return;
}
sql += string.Format(" and ProNo like '%{0}%'", txtProNo.Text.Trim());
}
if (txtGuestName.Text.Trim() != "")
{
sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text.Trim());
}
if (!string.IsNullOrEmpty(txtFPTotal.Text))
{
if (CommHelp.VerifesToNum(txtFPTotal.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('发票金额 格式错误！');</script>");
return;
}
sql += string.Format(" and Total {0}{1}", ddlPOFaTotal.Text, txtFPTotal.Text);
}
if (!string.IsNullOrEmpty(txtOldFPTotal.Text))
{
if (CommHelp.VerifesToNum(txtOldFPTotal.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('原金额 格式错误！');</script>");
return;
}
sql += string.Format(" and TopTotal {0}{1}", ddlOldPOFaTotal.Text, txtOldFPTotal.Text);
}
if (txtOldFPNo.Text != "")
{
sql += string.Format(" and TopFPNo like '%{0}%'", txtOldFPNo.Text);
}
if (ddlIsSelect.Text != "-1" && ddlIsClose.Text != "-1" && ddlJieIsSelected.Text != "-1" && ddlIsSpecial.Text != "-1" && ddlModel.Text != "全部")
{
sql += string.Format(" and exists(select id from CG_POOrder where Status='通过' and IsClose={0} and IsSelected={1} and JieIsSelected={2} and IsSpecial={3} and model={4} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlIsClose.Text, ddlIsSelect.Text, ddlJieIsSelected.Text,
ddlIsSpecial.Text, ddlModel.Text);
}
else
{
if (ddlIsClose.Text != "-1")
{
sql += string.Format(" and exists(select id from CG_POOrder where Status='通过' and IsClose={0} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlIsClose.Text);
}
if (ddlIsSelect.Text != "-1")
{
sql += string.Format("and exists(select id from CG_POOrder where Status='通过' and IsSelected={0} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlIsSelect.Text);
}
if (ddlJieIsSelected.Text != "-1")
{
sql += string.Format("and exists(select id from CG_POOrder where Status='通过' and JieIsSelected={0} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlJieIsSelected.Text);
}
if (ddlIsSpecial.Text != "-1")
{
sql += string.Format("and exists(select id from CG_POOrder where Status='通过' and IsSpecial={0} and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlIsSpecial.Text);
}
if (ddlModel.Text != "全部")
{
sql += string.Format("and exists(select id from CG_POOrder where Status='通过' and model='{0}' and CG_POOrder.PONO=Sell_OrderFP.PONO ) ", ddlModel.Text);
}
}
if (ddlUser.Text != "-1")
{
sql += string.Format(" and CreateUserId={0}", ddlUser.Text);
}
if (ddlCompany.Text != "-1")
{
string where = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[2]);
sql += string.Format(" and CreateUserId IN(select id from tb_User where {0})", where);
}
if (txtFPNo.Text.Trim() != "")
{
sql += string.Format(" and FPNo like '%{0}%'", txtFPNo.Text.Trim());
}
if (ddlType.Text == "0")
{
sql += string.Format(" and exists(select Sell_OrderFPBack.id from Sell_OrderFPBack where Status='通过' and FPNo=Sell_OrderFP.FPNo )");
}
if (ddlType.Text == "1")
{
sql += string.Format(" and not exists(select Sell_OrderFPBack.id from Sell_OrderFPBack where Status='通过' and FPNo=Sell_OrderFP.FPNo)");
}
if (ddlPOInvoiceState.Text == "1")//发票数<项目数
{
//sql += string.Format(" and exists(select PONO from POFP_View where PONO=Sell_OrderFP.PONO and SumPoTotal-TuiTotal>sumTotal )");
sql += string.Format(" and SumPoTotal-TuiTotal>sumTotal ");
}
else if (ddlPOInvoiceState.Text == "2")//发票数>项目数
{
//sql += string.Format(" and exists(select PONO from POFP_View where PONO=Sell_OrderFP.PONO and SumPoTotal-TuiTotal<sumTotal )");
sql += string.Format(" and SumPoTotal-TuiTotal<sumTotal ");
}
else if (ddlPOInvoiceState.Text == "3")//发票数=项目数
{
//sql += string.Format(" and exists(select PONO from POFP_View where PONO=Sell_OrderFP.PONO and SumPoTotal-TuiTotal=sumTotal )");
sql += string.Format(" and SumPoTotal-TuiTotal=sumTotal ");
}
if (ddlFPType.Text != "-1")
{
if (ddlFPType.SelectedItem.Text != "其他")
{
sql += string.Format(" and FPNoStyle='{0}'", ddlFPType.SelectedItem.Text);
}
else
{
sql += string.Format(" and FPNoStyle not in (select FpType from FpTypeBaseInfo) and FPNoStyle<>''");
}
}
if (ddlGuestTypeList.SelectedValue != "全部" || ddlGuestProList.SelectedValue != "-2")
{
string where = "";
if (ddlGuestTypeList.SelectedValue != "全部")
{
where += string.Format(" and GuestType='{0}'", ddlGuestTypeList.SelectedValue);
}
if (ddlGuestProList.SelectedValue != "-2")
{
where += string.Format(" and GuestPro={0}", ddlGuestProList.SelectedValue);
}
sql += string.Format("and exists(select id from CG_POOrder where Status='通过' {0} and CG_POOrder.PONO=Sell_OrderFP.PONO and IFZhui=0) ", where);
}
List <Sell_OrderFP> pOOrderList = this.POSer.GetListArray(sql);
decimal allTotal = 0;
decimal allPoTotal = 0;
System.Collections.Hashtable hs = new Hashtable();
foreach (var m in pOOrderList)
{
allTotal += m.Total;
if (!hs.Contains(m.PONo))
{
allPoTotal += m.AllPoTotal;
hs.Add(m.PONo, null);
}
}
lblAllTotal.Text = allTotal.ToString();
lblAllPoTotal.Text = allPoTotal.ToString();
AspNetPager1.RecordCount = pOOrderList.Count;
this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
//if (pOOrderList.Count > 0)
//{
// CG_POOrderService orderSer = new CG_POOrderService();
// var list = orderSer.GetOrder_ToInvoice_1(string.Format(" PONo='{0}'", pOOrderList[0].PONo));
// if (list.Count > 0)
// {
// lblPOTotal.Text = "项目(" + pOOrderList[0].PONo+")---" + (list[0].POTotal - list[0].TuiTotal).ToString();
// }
// else
// {
// lblPOTotal.Text = "0";
// }
//lblPOTotal.Text = "";
//}
//子单
List <Sell_OrderFPs> orders = new List <Sell_OrderFPs>();
gvList.DataSource = orders;
gvList.DataBind();
}
private void select()
{
string sql = " 1=1 ";
//QueryEForms
QuerySession.QueryEForm QEForm = new VAN_OA.QuerySession.QueryEForm();
if (ddlProType.SelectedItem != null && ddlProType.SelectedItem.Text != "")
{
if (ddlProType.SelectedItem.Value == "-2")
{
sql += string.Format(" and proId in (26,34)");
}
else if (ddlProType.SelectedItem.Value == "-3")
{
sql += string.Format(" and proId in (31,32)");
}
else
{
sql += string.Format(" and proId={0}", ddlProType.SelectedItem.Value);
}
QEForm.ProTypeId = Convert.ToInt32(ddlProType.SelectedItem.Value);
}
else
{
sql += " and pro_Type is not null";
}
if (txtFrom.Text != "")
{
if (CommHelp.VerifesToDateTime(txtFrom.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('申请时间 格式错误！');</script>");
return;
}
sql += string.Format(" and appTime>='{0} 00:00:00'", txtFrom.Text);
QEForm.FromTime = 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 appTime<='{0} 23:59:59'", txtTo.Text);
QEForm.ToTime = txtTo.Text;
}
if (ddlState.SelectedItem.Text != "")
{
sql += string.Format(" and state='{0}'", ddlState.SelectedItem.Text);
QEForm.State = ddlState.SelectedItem.Text;
}
if (txtSPForm.Text != "")
{
if (CommHelp.VerifesToDateTime(txtSPForm.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('审批时间 格式错误！');</script>");
return;
}
}
if (txtSPTo.Text != "")
{
if (CommHelp.VerifesToDateTime(txtSPTo.Text) == false)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('审批时间 格式错误！');</script>");
return;
}
}
if (txtSPForm.Text != "" && txtSPTo.Text != "")
{
sql += string.Format(" and isnull(maxDoTime,tb_EForm_View.createTime)>='{0} 00:00:00' and isnull(maxDoTime,tb_EForm_View.createTime)<='{1} 23:59:59' ",
txtSPForm.Text, txtSPTo.Text);
}
if (txtSPForm.Text == "" && txtSPTo.Text != "")
{
sql += string.Format(" and isnull(maxDoTime,tb_EForm_View.createTime)<='{0} 23:59:59'",
txtSPTo.Text);
}
if (txtSPForm.Text != "" && txtSPTo.Text == "")
{
sql += string.Format(" and isnull(maxDoTime,tb_EForm_View.createTime)>='{0} 00:00:00' ",
txtSPForm.Text);
}
QEForm.SPForm = txtSPForm.Text;
QEForm.SPTo = txtSPTo.Text;
if (ddlUser.Text != "-1")
{
sql += string.Format(" and appPer_Name like '%{0}%'", ddlUser.SelectedItem.Text);
QEForm.Apper = ddlUser.SelectedItem.Text;
}
if (txtAuper.Text != "")
{
sql += string.Format(" and id in (select e_Id from EForms_View where audPer_Name like '%{0}%' or consignor_Name like '%{0}%')", txtAuper.Text);
QEForm.Auper = txtAuper.Text;
}
if (txtWating.Text != "")
{
sql += string.Format(" and toPer_Name like '%{0}%'", txtWating.Text);
QEForm.WatingAuper = txtWating.Text;
}
if (txtNo.Text.Trim() != "")
{
if (CheckProNo(txtNo.Text) == false)
{
return;
}
sql += string.Format(" and e_No like '%{0}%'", txtNo.Text.Trim());
QEForm.E_No = txtNo.Text;
}
if (!string.IsNullOrEmpty(txtPOSupplier.Text.Trim()))
{
if (cbPiPei.Checked)
{
sql += string.Format(@" and proId in (31,32,33) and exists(select 1 from (select CAI_POCai.LastSupplier,TB_SupplierAdvancePayments.Id,32 as myProId from TB_SupplierAdvancePayments
left join CAI_POCai on TB_SupplierAdvancePayments.CaiIds=CAI_POCai.Ids
union all
select TB_SupplierInvoice.LastSupplier,TB_SupplierInvoice.Id,31 as myProId from TB_SupplierInvoice left join TB_SupplierInvoices on TB_SupplierInvoice.Id=TB_SupplierInvoices.Id
where IsYuFu=0
union all
select TB_SupplierInvoice.LastSupplier,TB_SupplierInvoice.Id,33 as myProId from TB_SupplierInvoice left join TB_SupplierInvoices on TB_SupplierInvoice.Id=TB_SupplierInvoices.Id
where IsYuFu=1
) as A where A.myProId=tb_EForm_View.proId and A.Id=tb_EForm_View.allE_id and LastSupplier='{0}' )", txtPOSupplier.Text.Trim());
}
else
{
sql += string.Format(@" and proId in (31,32,33) and exists(select 1 from (select CAI_POCai.LastSupplier,TB_SupplierAdvancePayments.Id,32 as myProId from TB_SupplierAdvancePayments
left join CAI_POCai on TB_SupplierAdvancePayments.CaiIds=CAI_POCai.Ids
union all
select TB_SupplierInvoice.LastSupplier,TB_SupplierInvoice.Id,31 as myProId from TB_SupplierInvoice left join TB_SupplierInvoices on TB_SupplierInvoice.Id=TB_SupplierInvoices.Id
where IsYuFu=0
union all
select TB_SupplierInvoice.LastSupplier,TB_SupplierInvoice.Id,33 as myProId from TB_SupplierInvoice left join TB_SupplierInvoices on TB_SupplierInvoice.Id=TB_SupplierInvoices.Id
where IsYuFu=1
) as A where A.myProId=tb_EForm_View.proId and A.Id=tb_EForm_View.allE_id and LastSupplier like '%{0}%' )", txtPOSupplier.Text.Trim());
}
}
#region 项目查询
string ponoSql = "";
if (ddlAEUsers.Text != "-1")
{
ponoSql += string.Format(" and CG_POOrder.AE='{0}'", ddlAEUsers.SelectedItem.Text);
}
if (txtPONo.Text.Trim() != "")
{
if (CheckPoNO(txtPONo.Text) == false)
{
return;
}
ponoSql += string.Format(" and CG_POOrder.PONo like '%{0}%'", txtPONo.Text.Trim());
QEForm.PONO = txtPONo.Text;
}
if (ddlCompany.Text != "-1")
{
string where = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[2]);
ponoSql += string.Format(" and CG_POOrder.AE IN(select LOGINNAME from tb_User where {0})", where);
}
if (txtGuestName.Text.Trim() != "")
{
ponoSql += string.Format(" and CG_POOrder.GuestName like '%{0}%'", txtGuestName.Text.Trim());
QEForm.GuestName = txtGuestName.Text.Trim();
}
if (CheckBox1.Checked)
{
ponoSql += string.Format(" and CG_POOrder.POStatue='{0}'", CheckBox1.Text);
}
if (CheckBox2.Checked)
{
ponoSql += string.Format(" and CG_POOrder.POStatue2='{0}'", CheckBox2.Text);
}
if (CheckBox3.Checked)
{
ponoSql += string.Format(" and CG_POOrder.POStatue3='{0}'", CheckBox3.Text);
}
if (CheckBox4.Checked)
{
ponoSql += string.Format(" and CG_POOrder.POStatue4='{0}'", CheckBox4.Text);
}
if (CheckBox5.Checked)
{
ponoSql += string.Format(" and CG_POOrder.POStatue5='{0}'", CheckBox5.Text);
}
if (CheckBox6.Checked)
{
ponoSql += string.Format(" and CG_POOrder.POStatue6='{0}'", CheckBox6.Text);
}
if (ddlClose.Text != "-1")
{
ponoSql += string.Format(" and CG_POOrder.IsClose={0} ", ddlClose.Text);
}
if (ddlIsSelect.Text != "-1")
{
ponoSql += string.Format(" and CG_POOrder.IsSelected={0} ", ddlIsSelect.Text);
}
if (ddlJieIsSelected.Text != "-1")
{
ponoSql += string.Format(" and CG_POOrder.JieIsSelected={0} ", ddlJieIsSelected.Text);
}
if (ddlIsSpecial.Text != "-1")
{
ponoSql += string.Format(" and CG_POOrder.IsSpecial={0} ", ddlIsSpecial.Text);
}
if (ddlHanShui.Text != "-1")
{
ponoSql += string.Format(" and CG_POOrder.IsPoFax={0} ", ddlHanShui.Text);
}
if (ddlPrice.Text == "1")
{
ponoSql += " and Order_ToInvoice_1.POTotal-isnull(TuiTotal,0)>0";
}
if (ddlPrice.Text == "0")
{
ponoSql += " and Order_ToInvoice_1.POTotal-isnull(TuiTotal,0)=0";
}
if (ponoSql != "")
{
sql += string.Format(" and EXISTS (SELECT 1 FROM CG_CAI_POOrder_View as CG_POOrder left join View_AllEform on CG_POOrder.pono=View_AllEform.pono ");
if (ddlPrice.Text != "-1")
{
sql += " left join Order_ToInvoice_1 on CG_POOrder.PONo=Order_ToInvoice_1.PONo ";
}
sql += string.Format(" WHERE View_AllEform.myProId=tb_EForm_View.proId and View_AllEform.Id=tb_EForm_View.allE_id {0})", ponoSql);
}
#endregion
Session["QueryEForms"] = QEForm;
tb_EFormService eformSer = new tb_EFormService();
PagerDomain page = new PagerDomain();
page.CurrentPageIndex = AspNetPager1.CurrentPageIndex;
List <tb_EForm> allEForms = eformSer.GetListArray_2_Page(sql, page);
AspNetPager1.RecordCount = page.TotalCount;
string allIds = "", proIds = "", fukuandan = "0,", yufukuandan = "0,";
for (int i = 0; i < allEForms.Count; i++)
{
allIds += allEForms[i].allE_id.ToString() + ",";
proIds += allEForms[i].proId.ToString() + ",";
if (allEForms[i].ProTyleName == "供应商付款单")
{
fukuandan += allEForms[i].allE_id + ",";
}
if (allEForms[i].ProTyleName == "供应商预付款单")
{
yufukuandan += allEForms[i].allE_id + ",";
}
}
allIds = allIds.Trim(',');
proIds = proIds.Trim(',');
fukuandan = fukuandan.Trim(',');
yufukuandan = yufukuandan.Trim(',');
if (fukuandan != "" || yufukuandan != "")
{
var superSer = new TB_SupplierAdvancePaymentService();
SupplierInvoice_Names = superSer.GetSupplierName(yufukuandan, fukuandan);
}
if (allIds != "")
{
allAllWform = eformSer.GetView_AllEformList(proIds, allIds);
}
this.gvList.DataSource = allEForms;
this.gvList.DataBind();
}
private void Show()
{
string sql = " ";
if (txtPONo.Text.Trim() != "")
{
if (CheckPoNO(txtPONo.Text) == false)
{
return;
}
sql += string.Format(" and CG_POOrder.PONo like '%{0}%'", txtPONo.Text.Trim());
}
if (ttxPOName.Text.Trim() != "")
{
sql += string.Format(" and CG_POOrder.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 CG_POOrder.PODate>='{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 CG_POOrder.PODate<='{0} 23:59:59'", txtTo.Text);
}
if (txtGuestName.Text.Trim() != "")
{
sql += string.Format(" and CG_POOrder.GuestName like '%{0}%'", txtGuestName.Text.Trim());
}
var isColse = "";
if (ddlIsClose.Text != "-1")
{
isColse = " and IsClose=" + ddlIsClose.Text;
}
if (ddlIsSelect.Text != "-1")
{
isColse = " and IsSelected=" + ddlIsSelect.Text;
}
if (ddlJieIsSelected.Text != "-1")
{
isColse = " and JieIsSelected=" + ddlJieIsSelected.Text;
}
if (ddlModel.Text != "全部")
{
sql += string.Format(" and Model='{0}'", ddlModel.Text);
}
//if (ViewState["showAll"] != null)
//{
// sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO )", Session["currentUserId"]);
//}
if (ddlUser.Text == "-1")//显示所有用户
{
if (cbIsSpecial.Checked)
{
sql += string.Format(" and EXISTS (select ID from CG_POOrder where IsSpecial=0 AND PONO=JXC_REPORT.PONO {0})", isColse);
}
//else
//{
// sql += string.Format(" and EXISTS (select ID from CG_POOrder where IsSpecial=1 AND PONO=JXC_REPORT.PONO {0})", isColse);
//}
//var model = Session["userInfo"] as User;
//sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职') AND PONO=JXC_REPORT.PONO )", Session["currentUserId"]);
}
//else if (ddlUser.Text == "0")//显示部门信息
//{
// var model = Session["userInfo"] as User;
// //sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName in (select ID from tb_User where 1=1 and loginName<>'admin' and loginStatus<>'离职' and loginIPosition<>'' and loginIPosition='{0}') AND PONO=JXC_REPORT.PONO )", model.LoginIPosition);
// if (cbIsSpecial.Checked)
// {
// sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO and IsSpecial=0 {1})", model.Id, isColse);
// }
// else
// {
// sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO and IsSpecial=1 {1})", model.Id, isColse);
// }
//}
else
{
if (cbIsSpecial.Checked)
{
sql += string.Format(" and EXISTS (select ID from CG_POOrder where AE='{0}' AND PONO=JXC_REPORT.PONO and IsSpecial=0 {1})", ddlUser.SelectedItem.Text, isColse);
}
else
{
sql += string.Format(" and EXISTS (select ID from CG_POOrder where AE='{0}' AND PONO=JXC_REPORT.PONO and IsSpecial=1 {1})", ddlUser.SelectedItem.Text, isColse);
}
//sql += string.Format(" and EXISTS (select ID from CG_POOrder where AppName={0} AND PONO=JXC_REPORT.PONO )", ddlUser.Text);
}
if (ddlCompany.Text != "-1")
{
string where = string.Format(" CompanyCode='{0}'", ddlCompany.Text.Split(',')[2]);
sql += string.Format(" and EXISTS (select ID from CG_POOrder where IFZhui=0 and AE IN(select LOGINNAME from tb_User where {0}) AND PONO=JXC_REPORT.PONO)", where);
}
if (CheckBox1.Checked || CheckBox2.Checked || CheckBox3.Checked || CheckBox4.Checked)
{
sql += " and exists ( select ID from CG_POOrder where PONO=JXC_REPORT.PONO";
if (CheckBox1.Checked)
{
sql += string.Format(" and POStatue='{0}'", CheckBox1.Text);
}
if (CheckBox2.Checked)
{
sql += string.Format(" and POStatue2='{0}'", CheckBox2.Text);
}
if (CheckBox3.Checked)
{
sql += string.Format(" and POStatue3='{0}'", CheckBox3.Text);
}
if (CheckBox4.Checked)
{
sql += string.Format(" and POStatue4='{0}'", CheckBox4.Text);
}
sql += ")";
}
string having = " having ";
if (CheckBox5.Checked && CheckBox6.Checked)
{
having += string.Format(" (avg(SellFPTotal)<> sum(goodSellTotal) or avg(SellFPTotal) is null) and (avg(InvoTotal)<> sum(goodSellTotal) or sum(InvoTotal) is null)");
}
else if (CheckBox5.Checked || CheckBox6.Checked)
{
if (CheckBox5.Checked)
{
having += string.Format(" avg(SellFPTotal)<> sum(goodSellTotal) or avg(SellFPTotal) is null ");
}
if (CheckBox6.Checked)
{
having += string.Format(" avg(InvoTotal)<> sum(goodSellTotal) or sum(InvoTotal) is null ");
}
}
else
{
having = "";
}
if (CheckBox8.Checked)
{
tiaoJian += "'" + CheckBox8.Text + "',";
}
if (CheckBox9.Checked)
{
tiaoJian += "'" + CheckBox9.Text + "',";
}
if (CheckBox10.Checked)
{
tiaoJian += "'" + CheckBox10.Text + "',";
}
if (CheckBox11.Checked)
{
tiaoJian += "'" + CheckBox11.Text + "',";
}
if (CheckBox12.Checked)
{
tiaoJian += "'" + CheckBox12.Text + "',";
}
if (CheckBox13.Checked)
{
tiaoJian += "'" + CheckBox13.Text + "',";
}
if (CheckBox14.Checked)
{
tiaoJian += "'" + CheckBox14.Text + "',";
}
if (CheckBox15.Checked)
{
tiaoJian += "'" + CheckBox15.Text + "',";
}
if (CheckBox16.Checked)
{
tiaoJian += "'" + CheckBox16.Text + "',";
}
if (CheckBox17.Checked)
{
tiaoJian += "'" + CheckBox17.Text + "',";
}
if (CheckBox7.Checked == false)
{
if (tiaoJian == "")
{
tiaoJian = "''";
}
}
List <JXC_REPORTTotal> pOOrderList = this.POSer.GetListArray_Items_Total(sql, having, tiaoJian);
var getAllPONos = pOOrderList.Aggregate("", (current, m) => current + ("'" + m.PONo + "',")).Trim(',');
lblVisAllPONO.Text = getAllPONos;
decimal HuiWuTotal = 0;
Hashtable hsPONo = new Hashtable();
decimal allTotal = 0;
decimal maoliTotal = 0;
decimal goodSellTotal = 0;
decimal TrueLiRun = 0;
decimal SellFPTotal = 0;
lblItemTotal.Text = pOOrderList.Sum(t => t.itemTotal).ToString();
foreach (var m in pOOrderList)
{
if (!hsPONo.Contains(m.PONo))
{
HuiWuTotal += m.HuiWuTotal;
allTotal += m.allItemTotal;
maoliTotal += m.maoliTotal;
goodSellTotal += m.goodSellTotal;
TrueLiRun += m.TrueLiRun;
SellFPTotal += m.SellFPTotal;
hsPONo.Add(m.PONo, null);
}
}
lblJLR.Text = string.Format("{0:n2}", maoliTotal);
lblXSE.Text = string.Format("{0:n2}", goodSellTotal);
lblSJLR.Text = string.Format("{0:n2}", TrueLiRun);
lblFP.Text = string.Format("{0:n2}", SellFPTotal);
lblHuiWuTotal.Text = string.Format("{0:n2}", HuiWuTotal);
lblAllItemTotal.Text = string.Format("{0:n2}", allTotal);
AspNetPager1.RecordCount = pOOrderList.Count;
this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1;
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
}
