protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); if (Session["currentUserId"] != null) { List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (VAN_OA.JXC.SysObj.IfShowAll("出库发票清单", Session["currentUserId"], "ShowAll") == false) { var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; List <SellFPReport> list = new List <SellFPReport>(); gvMain.DataSource = list; gvMain.DataBind(); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); List <FpTypeBaseInfo> gooQGooddList = fpTypeBaseInfoService.GetListArray(""); gooQGooddList.Insert(0, new FpTypeBaseInfo { FpType = "全部", Id = 0 }); dllFPstye.DataSource = gooQGooddList; dllFPstye.DataBind(); dllFPstye.DataTextField = "FpType"; dllFPstye.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='可导出' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='出库发票清单') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("出库发票清单", "可导出")) { Button1.Visible = true; } else { Button1.Visible = false; } if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); cbIsSpecial.Checked = false; Show(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); //主单 List <Sell_OrderFP> pOOrderList = new List <Sell_OrderFP>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //子单 List <Sell_OrderFPs> orders = new List <Sell_OrderFPs>(); gvList.DataSource = orders; gvList.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='查看所有' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='销售发票列表') and sys_Object.AutoID is not null", Session["currentUserId"]); if (QuanXian_ShowAll("销售发票列表") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='不能编辑' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='销售发票列表') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("销售发票列表", "不能编辑") == false) { gvMain.Columns[0].Visible = false; } if (NewShowAll_textName("销售发票列表", "删除") == false) { gvMain.Columns[2].Visible = false; } //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.Sell_OrderPFList, Session["currentUserId"]) == false) //{ // ViewState["showAll"] = false; //} var fpTypeBaseInfoService = new FpTypeBaseInfoService(); List <FpTypeBaseInfo> fpTypeList = fpTypeBaseInfoService.GetListArray(""); fpTypeList.Insert(0, new FpTypeBaseInfo { FpType = "全部", Id = -1 }); fpTypeList.Add(new FpTypeBaseInfo { Id = 999, FpType = "" }); fpTypeList.Add(new FpTypeBaseInfo { Id = 1000, FpType = "其他" }); ddlFPType.DataSource = fpTypeList; ddlFPType.DataBind(); ddlFPType.DataTextField = "FpType"; ddlFPType.DataValueField = "Id"; ddlFPType.Items[fpTypeList.Count - 2].Attributes.Add("style", "background-color: red"); GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2 }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); if (Request["Type"] != null) { ddlType.Text = Request["Type"].ToString(); } Show(); } if (Request["InvoiceNo"] != null) { txtFPNo.Text = Request["InvoiceNo"].ToString(); Show(); } } }
private void Show() { ddlFPType.Items[ddlFPType.Items.Count - 2].Attributes.Add("style", "background-color: red"); _basePoTypeList = new TB_BasePoTypeService().GetListArray(""); _basePoTypeList.Insert(0, new TB_BasePoType { BasePoType = "", Id = -1 }); _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "" }); _guestTypeList = dal.GetListArray(""); _guestTypeList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "" }); _guestProList = guestProBaseInfodal.GetListArray(""); _guestProList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -1 }); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); gooQGooddList = fpTypeBaseInfoService.GetListArray(""); gooQGooddList.Add(new FpTypeBaseInfo { FpType = "" }); allFpTypes = gooQGooddList.Select(t => t.FpType).ToList(); var sql = ""; if (txtPONo.Text.Trim() != "") { if (CheckPoNO(txtPONo.Text) == false) { return; } sql += string.Format(" and CG_POOrder.PONo like '%{0}%'", txtPONo.Text.Trim()); } if (!string.IsNullOrEmpty(txtPOName.Text)) { sql += string.Format(" and PONAME like '%{0}%'", txtPOName.Text.Trim()); } if (txtPlanDayForm.Text != "") { if (CommHelp.VerifesToNum(txtPlanDayForm.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('计划完工天数 格式错误!');</script>"); return; } sql += string.Format(" and {1}{0}PlanDays", ddlPlanDayForm.Text, txtPlanDayForm.Text); } if (txtPlanDayTo.Text != "") { if (CommHelp.VerifesToNum(txtPlanDayTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('计划完工天数 格式错误!');</script>"); return; } sql += string.Format(" and PlanDays{0}{1}", ddlPlanDayTo.Text, txtPlanDayTo.Text); } if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目日期 格式错误!');</script>"); return; } sql += string.Format(" and 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 PODate<='{0} 23:59:59'", txtTo.Text); } if (txtProNo.Text.Trim() != "") { if (CheckProNo(txtProNo.Text) == false) { return; } sql += string.Format(" and ProNo like '%{0}%'", txtProNo.Text.Trim()); } if (ddlUser.Text != "-1") { var strSql = new System.Text.StringBuilder(); int month = DateTime.Now.Month; int year = DateTime.Now.Year; if (1 <= month && month <= 3) { strSql.Append(string.Format(" and QuartNo='1' and YearNo='{0}' ", year)); } else if (4 <= month && month <= 6) { strSql.Append(string.Format(" and QuartNo='2' and YearNo='{0}' ", year)); } else if (7 <= month && month <= 9) { strSql.Append(string.Format(" and QuartNo='3' and YearNo='{0}' ", year)); } else if (10 <= month && month <= 12) { strSql.Append(string.Format(" and QuartNo='4' and YearNo='{0}' ", year)); } // sql += string.Format(" and AppName={0}", ddlUser.Text); 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 (ddlSpecial.Text != "-1") { sql += string.Format(" and IsSpecial={0}", ddlSpecial.Text); } if (ddlNoSelected.Text != "-1") { sql += string.Format(" and IsSelected=" + ddlNoSelected.Text); } if (ddlJieIsSelected.Text != "-1") { sql += string.Format(" and JieIsSelected=" + ddlJieIsSelected.Text); } if (ddlColse.Text != "-1") { sql += string.Format(" and IsClose={0}", ddlColse.Text); } if (ddlIsPoFax.Text != "-1") { sql += string.Format(" and IsPoFax={0}", ddlIsPoFax.Text); if (ddlIsPoFax.Text == "1" && dllFPstye.Text != "-1") { sql += string.Format(" and FpType='" + dllFPstye.SelectedItem.Text + "'"); } } if (ddlPOTyle.Text != "-1") { sql += string.Format(" and POType=" + ddlPOTyle.Text); } if (ddlJiLiang.Text != "-1") { sql += string.Format(" and ChengBenJiLiang=" + ddlJiLiang.Text); } if (ddlModel.Text != "全部") { sql += string.Format(" and Model='{0}'", ddlModel.Text); } if (!string.IsNullOrEmpty(txtPoTotal.Text)) { if (CommHelp.VerifesToNum(txtPoTotal.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目金额 格式错误!');</script>"); return; } sql += string.Format(" and SumPOTotal{0}{1}", ddlFuHao.Text, txtPoTotal.Text); } if (!string.IsNullOrEmpty(txtGuestName.Text.Trim())) { sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text.Trim()); } if (ddlFPType.Text != "-1") { if (ddlFPType.SelectedItem.Text != "其他") { sql += string.Format(" and FPType='{0}'", ddlFPType.SelectedItem.Text); } else { sql += string.Format(" and FPType not in (select FpType from FpTypeBaseInfo) and FPType<>''"); } } if (txtEque1.Text != "") { if (CommHelp.VerifesToNum(txtEque1.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目金额 格式错误!');</script>"); return; } sql += string.Format(" and {1}{0}SumPOTotal", ddlEque1.Text, txtEque1.Text); } if (txtEque2.Text != "") { if (CommHelp.VerifesToNum(txtEque2.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目金额 格式错误!');</script>"); return; } sql += string.Format(" and SumPOTotal{0}{1}", ddlEque2.Text, txtEque2.Text); } if (ddlGuestTypeList.SelectedValue != "全部") { sql += string.Format(" and GuestType='{0}'", ddlGuestTypeList.SelectedValue); } if (ddlGuestProList.SelectedValue != "-2") { if (ddlGuestProList.SelectedValue == "-1") { sql += string.Format(" and GuestPro not in (0,1,2)"); } else { sql += string.Format(" and GuestPro={0}", ddlGuestProList.SelectedValue); } } var dt = this.POSer.SetPoSpecial(sql); //foreach (DataRow dr in dt.Rows) //{ // if (ViewState["isCloseEdist"] != null) // dr["isCloseEdist"] = false; // else // { // dr["isCloseEdist"] = true; // } //} AspNetPager1.RecordCount = dt.Rows.Count; this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvMain.DataSource = dt; this.gvMain.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { string where = " PONo in ("; string expWhere = " PONo in ("; if (ViewState["isSpecialEdit"] == null) { if (CheckIsSpecial() == false) { return; } for (int i = 0; i < this.gvMain.Rows.Count; i++) { CheckBox cb = (gvMain.Rows[i].FindControl("cbIsSpecial")) as CheckBox; if (cb.Checked) { Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; where += "'" + lblIds.Text + "',"; } else { Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; expWhere += "'" + lblIds.Text + "',"; } } if (where != " PONo in (") { where = where.Substring(0, where.Length - 1) + ")"; var sql = "update CG_POOrder set IsSpecial=1 where " + where; DBHelp.ExeCommand(sql); //base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); } if (expWhere != " PONo in (") { expWhere = expWhere.Substring(0, expWhere.Length - 1) + ")"; var sql = "update CG_POOrder set IsSpecial=0 where " + expWhere; DBHelp.ExeCommand(sql); // base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); } } if (ViewState["isChengBenJiLiang"] == null) { where = " PONo in ("; expWhere = " PONo in ("; for (int i = 0; i < this.gvMain.Rows.Count; i++) { CheckBox cb = (gvMain.Rows[i].FindControl("cbChengBenJiLiang")) as CheckBox; if (cb.Checked) { Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; where += "'" + lblIds.Text + "',"; } else { Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; expWhere += "'" + lblIds.Text + "',"; } } if (where != " PONo in (") { where = where.Substring(0, where.Length - 1) + ")"; var sql = "update CG_POOrder set ChengBenJiLiang=1 where " + where; DBHelp.ExeCommand(sql); //base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); } if (expWhere != " PONo in (") { expWhere = expWhere.Substring(0, expWhere.Length - 1) + ")"; var sql = "update CG_POOrder set ChengBenJiLiang=0 where " + expWhere; DBHelp.ExeCommand(sql); // base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); } } if (ViewState["isPOType"] == null) { //保存含税信息 using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = conn.CreateCommand(); for (int i = 0; i < this.gvMain.Rows.Count; i++) { Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; DropDownList drp = ((DropDownList)gvMain.Rows[i].FindControl("dllPOType")); objCommand.CommandText = string.Format("update CG_POOrder set POType={1} where PONO='{0}'", lblIds.Text, drp.Text); objCommand.ExecuteNonQuery(); } conn.Close(); } ////保存含税信息 //where = " PONo in ("; //expWhere = " POType in ("; // for (int i = 0; i < this.gvMain.Rows.Count; i++) // { // Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; // DropDownList drp = ((DropDownList)gvMain.Rows[i].FindControl("dllPOType")); // //if (drp.Text == "1") // //{ // where += "'" + lblIds.Text + "',"; // expWhere += "" + drp.Text + ","; // //} // //if (drp.Text == "2") // //{ // // expWhere += "'" + lblIds.Text + "',"; // //} // } // if (where != " PONo in (") // { // where = where.Substring(0, where.Length - 1) + ")"; // var sql = "update CG_POOrder set POType=1 where " + where; // DBHelp.ExeCommand(sql); // } //if (expWhere != " PONo in (") //{ // expWhere = expWhere.Substring(0, expWhere.Length - 1) + ")"; // var sql = "update CG_POOrder set POType=2 where " + expWhere; // DBHelp.ExeCommand(sql); //} } //项目模型 if (ViewState["isModelEdit"] == null) { //保存项目模型信息 using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = conn.CreateCommand(); for (int i = 0; i < this.gvMain.Rows.Count; i++) { Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; DropDownList drp = ((DropDownList)gvMain.Rows[i].FindControl("ddlModel")); objCommand.CommandText = string.Format("update CG_POOrder set Model='{1}' where PONO='{0}'", lblIds.Text, drp.Text); objCommand.ExecuteNonQuery(); } conn.Close(); } } if (ViewState["isFaxEdist"] == null) { //保存含税信息 expWhere = " PONo in ("; var fpTypeBaseInfoService = new FpTypeBaseInfoService(); gooQGooddList = fpTypeBaseInfoService.GetListArray(""); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = conn.CreateCommand(); for (int i = 0; i < this.gvMain.Rows.Count; i++) { CheckBox cb = (gvMain.Rows[i].FindControl("cbIsPoFax")) as CheckBox; if (cb.Checked) { Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; //where += "'" + lblIds.Text + "',"; DropDownList drp = ((DropDownList)gvMain.Rows[i].FindControl("dllFPstye")); objCommand.CommandText = string.Format("update CG_POOrder set IsPoFax=1, FpType='{1}',FpTax={2} where PONO='{0}'", lblIds.Text, drp.Text, gooQGooddList.Find(p => p.FpType == drp.Text).Tax); objCommand.ExecuteNonQuery(); } else { Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; expWhere += "'" + lblIds.Text + "',"; } } conn.Close(); } if (expWhere != " PONo in (") { expWhere = expWhere.Substring(0, expWhere.Length - 1) + ")"; var sql = "update CG_POOrder set IsPoFax=0,FpType='',FpTax=0 where " + expWhere; DBHelp.ExeCommand(sql); } } if (ViewState["isPlanDays"] == null) { //保存含税信息 expWhere = " PONo in ("; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = conn.CreateCommand(); for (int i = 0; i < this.gvMain.Rows.Count; i++) { TextBox txtPlanDayForm = (gvMain.Rows[i].FindControl("txtPlanDays")) as TextBox; if (CommHelp.VerifesToNum(txtPlanDayForm.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('计划完工天数 格式错误!');</script>"); return; } Label lblIds = (gvMain.Rows[i].FindControl("PONo")) as Label; objCommand.CommandText = string.Format("update CG_POOrder set PlanDays={1} where PONO='{0}'", lblIds.Text, txtPlanDayForm.Text); objCommand.ExecuteNonQuery(); } conn.Close(); } } base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); //AspNetPager1.CurrentPageIndex = 1; Show(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; this.gvModel.DataSource = modelService.GetListArray("");; this.gvModel.DataBind(); TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); if (NewShowAll_textName("项目归类", "关闭可编辑") == false) { ViewState["isCloseEdist"] = false; btnSaveIsClose.Visible = false; } if (NewShowAll_textName("项目归类", "特殊可编辑") == false) { ViewState["isSpecialEdit"] = false; } if (NewShowAll_textName("项目归类", "项目模型可编辑") == false) { ViewState["isModelEdit"] = false; } if (NewShowAll_textName("项目归类", "项目类型可编辑") == false) { ViewState["isPOType"] = false; } if (NewShowAll_textName("项目归类", "含税可编辑") == false) { ViewState["isFaxEdist"] = false; } if (NewShowAll_textName("项目归类", "发票类型可编辑") == false) { ViewState["isFPTypeEdist"] = false; } if (NewShowAll_textName("项目归类", "选中可编辑") == false) { ViewState["cbIsSelected"] = false; btnIsSelected.Visible = false; } if (NewShowAll_textName("项目归类", "结算选中可编辑") == false) { ViewState["IsJieIsSelected"] = false; btnJieIsSelected.Visible = false; } if (NewShowAll_textName("项目归类", "财务成本计量可编辑") == false) { ViewState["isChengBenJiLiang"] = false; } if (NewShowAll_textName("项目归类", "计划完工天数可编辑") == false) { ViewState["isPlanDays"] = false; } if (NewShowAll_textName("项目归类", "客户类型可编辑") == false) { ViewState["isGuestType"] = false; btnGuestType.Visible = false; } if (NewShowAll_textName("项目归类", "客户属性可编辑") == false) { ViewState["isGuestPro"] = false; btnGuestPro.Visible = false; } var user = new List <Model.User>(); var userSer = new Dal.SysUserService(); //主单 var pOOrderList = new List <CG_POOrderService>(); gvMain.DataSource = pOOrderList; gvMain.DataBind(); if (QuanXian_ShowAll("项目归类") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; var fpTypeBaseInfoService = new FpTypeBaseInfoService(); List <FpTypeBaseInfo> fpTypeList = fpTypeBaseInfoService.GetListArray(""); fpTypeList.Insert(0, new FpTypeBaseInfo { FpType = "全部", Id = -1 }); fpTypeList.Add(new FpTypeBaseInfo { Id = 999, FpType = "" }); dllFPstye.DataSource = fpTypeList; dllFPstye.DataBind(); dllFPstye.DataTextField = "FpType"; dllFPstye.DataValueField = "Id"; dllFPstye.Items[fpTypeList.Count - 1].Attributes.Add("style", "background-color: red"); List <FpTypeBaseInfo> newFpTypeList = new List <FpTypeBaseInfo>(); foreach (var fp in fpTypeList) { newFpTypeList.Add(new FpTypeBaseInfo { Id = fp.Id, FpType = fp.FpType }); } newFpTypeList.Add(new FpTypeBaseInfo { Id = 1000, FpType = "其他" }); ddlFPType.DataSource = newFpTypeList; ddlFPType.DataBind(); ddlFPType.DataTextField = "FpType"; ddlFPType.DataValueField = "Id"; ddlFPType.Items[newFpTypeList.Count - 2].Attributes.Add("style", "background-color: red"); List <TB_BasePoType> basePoTypeList = new TB_BasePoTypeService().GetListArray(""); basePoTypeList.Insert(0, new TB_BasePoType { BasePoType = "全部", Id = -1 }); ddlPOTyle.DataSource = basePoTypeList; ddlPOTyle.DataBind(); ddlPOTyle.DataTextField = "BasePoType"; ddlPOTyle.DataValueField = "Id"; GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "" }); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -1 }); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2, }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); gooQGooddList_1 = fpTypeBaseInfoService.GetListArray(""); gooQGooddList_1.Insert(0, new FpTypeBaseInfo() { FpType = "全部" }); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (NewShowAll_textName("采购订单列表2", "查看所有") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (NewShowAll_textName("采购订单列表2", "禁止含税设置") == false) { gvMain.Columns[0].Visible = false; btnSave.Visible = false; } else { gvMain.Columns[1].Visible = false; } if (NewShowAll_textName("采购订单列表2", "可导出") == false) { btnExcel.Visible = false; } //主单 List <vAllCaiOrderList> pOOrderList = new List <vAllCaiOrderList>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //发票类型 dllSelectFPstye.DataSource = gooQGooddList_1; dllSelectFPstye.DataTextField = "FpType"; dllSelectFPstye.DataValueField = "FpType"; dllSelectFPstye.DataBind(); // } }
private string GetSql() { var fpTypeBaseInfoService = new FpTypeBaseInfoService(); gooQGooddList = fpTypeBaseInfoService.GetListArray(""); allFpTypes = gooQGooddList.Select(t => t.FpType).ToList(); string sql = " 1=1 "; if (txtPONo.Text.Trim() != "") { sql += string.Format(" and PONo like '%{0}%'", txtPONo.Text.Trim()); } string notInPoNo = ""; if (txtPONO1.Text.Trim() != "") { notInPoNo += string.Format("'{0}',", txtPONO1.Text.Trim()); } if (txtPONO2.Text.Trim() != "") { notInPoNo += string.Format("'{0}',", txtPONO2.Text.Trim()); } if (txtPONO3.Text.Trim() != "") { notInPoNo += string.Format("'{0}',", txtPONO3.Text.Trim()); } if (!string.IsNullOrEmpty(notInPoNo)) { sql += string.Format(" and PONo not in ({0})", notInPoNo.Trim(',')); } if (ttxPOName.Text.Trim() != "") { sql += string.Format(" and POName like '%{0}%'", ttxPOName.Text.Trim()); } if (txtProDateFrom.Text != "") { sql += string.Format(" and PODate>='{0} 00:00:00'", txtProDateFrom.Text); } if (txtProDateTo.Text != "") { sql += string.Format(" and PODate<='{0} 23:59:59'", txtProDateTo.Text); } if (txtFrom.Text != "" || txtTo.Text != "") { string where = ""; if (txtFrom.Text != "") { where += string.Format(" and PODate>='{0} 00:00:00'", txtFrom.Text); } if (txtTo.Text != "") { where += string.Format(" and PODate<='{0} 23:59:59'", txtTo.Text); } sql += string.Format(@" and (EXISTS(SELECT ID FROM CG_POOrder WHERE IFZhui=0 AND CG_POOrder.PONo=vAllCaiOrderList.PONo {0} ) OR EXISTS (select id from CAI_POOrder where PONo like 'KC%' AND CAI_POOrder.PONo=vAllCaiOrderList.PONo {0} ))", where); } if (!string.IsNullOrEmpty(txtAuditDate.Text)) { sql += " and exists( select id from tb_EForm where tb_EForm.allE_id=vAllCaiOrderList.id and proId=20 "; sql += string.Format(" and e_LastTime>='{0} 00:00:00'", txtAuditDate.Text); sql += string.Format(" and e_LastTime<='{0} 23:59:59'", txtAuditDate.Text); sql += " )"; } if (ddlStatue.Text != "") { sql += string.Format(" and Status='{0}'", ddlStatue.Text); } else { sql += string.Format(" and Status<>'不通过'"); } if (txtGuestName.Text.Trim() != "") { sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text.Trim()); } if (ddlBusType.Text != "") { sql += string.Format(" and BusType='{0}'", ddlBusType.SelectedValue); } if (txtPoProNo.Text.Trim() != "") { sql += string.Format(" and CG_ProNo like '%{0}%'", txtPoProNo.Text.Trim()); } if (txtCaiugou.Text != "") { sql += string.Format(" and CaiGou like '%{0}%'", txtCaiugou.Text); } if (ddlUser.Text != "-1") { //sql += string.Format(" and (AppName={0} or exists(select id from CG_POOrder where CG_POOrder.PONo=vAllCaiOrderList.PONo and AppName={0}))", ddlUser.Text); 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 exists (select id from CG_POOrder where IFZhui=0 and CG_POOrder.PONo=vAllCaiOrderList.PONo and AppName in(select id from tb_User where {0}))", where); } if (txtGoodNo.Text.Trim() != "") { sql += string.Format(" and GoodNo like '%{0}%'", txtGoodNo.Text.Trim()); } if (txtLastSupplier.Text.Trim() != "") { if (cbPiPei.Checked) { sql += string.Format(" and lastSupplier='{0}'", txtLastSupplier.Text.Trim()); } else { sql += string.Format(" and lastSupplier like '%{0}%'", txtLastSupplier.Text.Trim()); } } if (ddlCaiGou.Text == "1") { sql += string.Format(" and lastSupplier<>'库存'"); } if (ddlCaiGou.Text == "0") { sql += string.Format(" and lastSupplier='库存'"); } if (ddlHanShui.Text != "-1") { sql += string.Format(" and IsHanShui={0} ", ddlHanShui.Text); } if (dllSelectFPstye.Text != "全部") { sql += string.Format(" and CaiFpType='{0}'", dllSelectFPstye.Text); } if (txtNameOrTypeOrSpec.Text != "" || txtNameOrTypeOrSpecTwo.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 (txtNameOrTypeOrSpec2.Text != "" || txtNameOrTypeOrSpecTwo2.Text != "") { if (txtNameOrTypeOrSpec2.Text != "" && txtNameOrTypeOrSpecTwo2.Text != "") { sql += string.Format(" and ((GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%') and (GoodTypeSmName like '%{1}%' or GoodName like '%{1}%' or GoodSpec like '%{1}%'))", txtNameOrTypeOrSpec2.Text, txtNameOrTypeOrSpecTwo2.Text); } else if (txtNameOrTypeOrSpec2.Text != "" || txtNameOrTypeOrSpecTwo2.Text != "") { var NameOrTypeOrSpec = ""; if (txtNameOrTypeOrSpec2.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpec2.Text; } if (txtNameOrTypeOrSpecTwo2.Text != "") { NameOrTypeOrSpec = txtNameOrTypeOrSpecTwo2.Text; } sql += string.Format(" and (GoodTypeSmName like '%{0}%' or GoodName like '%{0}%' or GoodSpec like '%{0}%')", NameOrTypeOrSpec); } } if (txtCaiNum.Text.Trim() != "") { sql += string.Format(" and Num{0} {1}", ddlCaiNum.Text, txtCaiNum.Text.Trim()); } if (txtCaiPrice.Text.Trim() != "") { sql += string.Format(" and lastPrice{0} {1}", ddlCaiPrice.Text, txtCaiPrice.Text.Trim()); } if (!string.IsNullOrEmpty(txtProNo.Text.Trim())) { sql += string.Format(" and ProNo like '%{0}%'", txtProNo.Text.Trim()); } if (ddlIsSpecial.Text != "-1") { sql += string.Format("and exists(select id from CG_POOrder where Status='通过' and IsSpecial={0} and CG_POOrder.PONO=vAllCaiOrderList.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=vAllCaiOrderList.PONO ) ", ddlModel.Text); } return(sql); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2 }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); gvDiXiao.DataSource = new List <SupplierToInvoiceView>(); gvDiXiao.DataBind(); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); List <FpTypeBaseInfo> gooQGooddList = fpTypeBaseInfoService.GetListArray(""); gooQGooddList.Insert(0, new FpTypeBaseInfo { Id = -1, FpType = "全部" }); gooQGooddList.Add(new FpTypeBaseInfo { Id = -2, FpType = "不含税" }); dllFPstye.DataSource = gooQGooddList; dllFPstye.DataBind(); dllFPstye.DataTextField = "FpType"; dllFPstye.DataValueField = "Id"; List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='查看所有' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='支付单列表') and sys_Object.AutoID is not null", Session["currentUserId"]); if (QuanXian_ShowAll("支付单列表") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='不能编辑' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='支付单列表') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("支付单列表", "不能编辑") == false) { gvMain.Columns[0].Visible = false; } var sql = @"select CreateName from ( select CreateName from TB_SupplierAdvancePayment union select CreateName from TB_SupplierInvoice) AS TB WHERE CreateName<>'ADMIN' ORDER BY CreateName "; List <ListItem> createList = new List <ListItem>(); createList.Add(new ListItem { Text = "全部", Value = "全部" }); createList.Add(new ListItem { Text = "不含Admin", Value = "不含Admin" }); foreach (DataRow dr in DBHelp.getDataTable(sql).Rows) { createList.Add(new ListItem { Text = dr[0].ToString(), Value = dr[0].ToString() }); } ddlCreateName.DataSource = createList; ddlCreateName.DataBind(); if (Request["Ids"] != null) { ddlStatue.Text = "通过"; ddlType.Text = "0"; Show(); } else { if (Request["PayIds"] != null) { ddlStatue.Text = "通过"; ddlType.Text = "1"; Show(); } else { //主单 List <SupplierToInvoiceView> pOOrderList = new List <SupplierToInvoiceView>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); } } } }
private void Show() { int doIt = Convert.ToInt32(ViewState["doIt"]); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); gooQGooddList = fpTypeBaseInfoService.GetListArray(""); allFpTypes = gooQGooddList.Select(t => t.FpType).ToList(); 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; } if (txtBai.Text == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('到款金额大小不能为空!');</script>"); return; } try { if (Convert.ToInt32(txtBai.Text) > 100 || (Convert.ToInt32(txtBai.Text) < 0)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('到款金额大小范围0%--100%!');</script>"); return; } } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('到款金额大小范围0%--100%!');</script>"); return; } var sql = ""; if (txtFrom.Text != "") { sql += string.Format(" and CG_POOrder.PODate>='{0} 00:00:00'", txtFrom.Text); } if (txtTo.Text != "") { sql += string.Format(" and CG_POOrder.PODate<='{0} 23:59:59'", txtTo.Text); } if (ddlCompany.Text != "-1") { sql += string.Format(" and exists (select tb_User.id from tb_User where CompanyCode='{0}' and tb_User.loginName=CG_POOrder.ae)", ddlCompany.Text); } if (ddlPOTyle.Text != "-1") { sql += string.Format(" and CG_POOrder.POType={0} ", ddlPOTyle.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 (ddlModel.Text != "全部") { sql += string.Format(" and Model='{0}'", ddlModel.Text); } //查询 if (doIt == 0) { if ((txtLeftPoTotal.Text.Trim() != "" && CommHelp.VerifesToNum(txtLeftPoTotal.Text) == false) || (txtRightPoTotal.Text.Trim() != "" && CommHelp.VerifesToNum(txtRightPoTotal.Text) == false)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目金额 格式错误!');</script>"); return; } if ((txtLeftJingLi.Text.Trim() != "" && CommHelp.VerifesToNum(txtLeftJingLi.Text) == false) || (txtRightJingLi.Text.Trim() != "" && CommHelp.VerifesToNum(txtRightJingLi.Text) == false)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('项目净利 格式错误!');</script>"); return; } if (txtLeftJingLi.Text.Trim() != "") { sql += string.Format(" and {0}{1}isnull(maoliTotal,0)", txtLeftJingLi.Text, ddlLeftJingLi.Text); } if (txtRightJingLi.Text.Trim() != "") { sql += string.Format(" and isnull(maoliTotal,0){0}{1}", ddlRightJingLi.Text, txtRightJingLi.Text); } if (txtLeftPoTotal.Text.Trim() != "") { sql += string.Format(" and {0}{1}(newtable1.POTotal-isnull(TuiTotal,0))", txtLeftPoTotal.Text, ddlLeftPoTotal.Text); } if (txtRightPoTotal.Text.Trim() != "") { sql += string.Format(" and (newtable1.POTotal-isnull(TuiTotal,0)){0}{1}", ddlRightPoTotal.Text, txtRightPoTotal.Text); } if (ddlIsSpecial.Text != "-1") { sql += string.Format(" and IsSpecial={0} ", ddlIsSpecial.Text); } if (ddlClose.Text != "-1") { sql += string.Format(" and IsClose={0} ", ddlClose.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 (ddlHanShui.Text != "-1") { sql += string.Format(" and IsPoFax={0} ", ddlHanShui.Text); } if (txtPONo.Text.Trim() != "") { if (CheckPoNO(txtPONo.Text) == false) { return; } txtPONo.Text = txtPONo.Text.Trim(); sql += string.Format(" and CG_POOrder.PONo like '%{0}%'", txtPONo.Text.Trim()); } if (ttxPOName.Text.Trim() != "") { sql += string.Format(" and POName like '%{0}%'", ttxPOName.Text.Trim()); } 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 (doIt == 1) { sql += string.Format(" and IsSpecial=0 "); } var dt = this.POSer.FIN_SetPoSpecial(sql); if (doIt == 0) { if (ddlFuHao.Text == ">=") { dt = dt.FindAll(t => t.BILI >= Convert.ToDecimal(txtBai.Text)); } if (ddlFuHao.Text == ">") { dt = dt.FindAll(t => t.BILI > Convert.ToDecimal(txtBai.Text)); } if (ddlFuHao.Text == "<") { dt = dt.FindAll(t => t.BILI < Convert.ToDecimal(txtBai.Text)); } if (ddlFuHao.Text == "<=") { dt = dt.FindAll(t => t.BILI <= Convert.ToDecimal(txtBai.Text)); } if (ddlFuHao.Text == "=") { dt = dt.FindAll(t => t.BILI == Convert.ToDecimal(txtBai.Text)); } } if (dt.Count > 0 && doIt == 1)//自动选中 { Do(dt, Convert.ToDecimal(txtBai.Text), ddlFuHao.Text); dt = this.POSer.FIN_SetPoSpecial(sql); } if (dt.Count > 0 && doIt == 2)//取消选中 { Do_Cancel(dt); dt = this.POSer.FIN_SetPoSpecial(sql); } if (dt.Count == 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('没有找到数据!');</script>"); } AspNetPager1.RecordCount = dt.Count; this.gvMain.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvMain.DataSource = dt; this.gvMain.DataBind(); }