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