protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//主单
List <Sell_Cai_OrderInHouseListModel> pOOrderList = new List <Sell_Cai_OrderInHouseListModel>();
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
if (QuanXian_ShowAll(SysObj.Sell_OrderInHouseList) == 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";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
TB_CompanyService comSer = new TB_CompanyService();
var comList = comSer.GetListArray("");
foreach (var m in comList)
{
m.ComCode += "," + m.ComSimpName;
}
comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
{
ComCode = "-1", ComName = "全部"
});
ddlCompany.DataSource = comList;
ddlCompany.DataBind();
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
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";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//主单
List <CG_POOrder> pOOrderList = new List <CG_POOrder>();
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
bool showAll = true;
if (QuanXian_ShowAll(SysObj.CG_OrderList) == false)
{
ViewState["showAll"] = false;
showAll = false;
}
if (Request["PONo"] != null)
{
txtPONo.Text = Request["PONo"].ToString();
Show();
}
bool WFScanDepartList = true;
if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll(SysObj.CG_OrderList, Session["currentUserId"], "WFScanDepartList") == true)
{
ViewState["WFScanDepartList"] = false;
WFScanDepartList = false;
}
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
if (showAll == true)
{
user = userSer.getAllUserByLoginName("");
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = -1
});
}
else if (WFScanDepartList == true)
{
user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]));
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = 0
});
}
else
{
var model = Session["userInfo"] as User;
user.Insert(0, model);
}
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
}
}
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_OrderInHouse> pOOrderList = new List <Sell_OrderInHouse>();
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
//子单
List <Sell_OrderInHouses> orders = new List <Sell_OrderInHouses>();
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();
if (QuanXian_ShowAll(SysObj.Sell_OrderInHouseList) == 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";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.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";
if (!NewShowAll_textName("签呈单档案管理", "编辑"))
{
gvList.Columns[0].Visible = false;
btnAdd.Visible = false;
}
if (!NewShowAll_textName("签呈单档案管理", "删除"))
{
gvList.Columns[1].Visible = false;
}
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getAllUserByLoginName("");
user.Insert(0, new Model.User {
LoginName = "全部"
});
ddlHandler.DataSource = user;
ddlHandler.DataBind();
ddlHandler.DataTextField = "LoginName";
ddlHandler.DataValueField = "LoginName";
var aeList = userSer.getAllUserByPOList("");
aeList.Insert(0, new Model.User {
LoginName = "全部"
});
ddlAE.DataSource = aeList;
ddlAE.DataBind();
ddlAE.DataTextField = "LoginName";
ddlAE.DataValueField = "LoginName";
List <Contract> contractList = new List <Contract>();
this.gvList.DataSource = contractList;
this.gvList.DataBind();
if (Request["PONO"] != null)
{
txtPONo.Text = Request["PONO"].ToString();
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 <InvoiceReport> invoiceList = new List <InvoiceReport>();
this.gvList.DataSource = invoiceList;
this.gvList.DataBind();
txtPOFrom.Text = DateTime.Now.AddYears(-1).Year + "-1-1";
var user = new List <VAN_OA.Model.User>();
var userSer = new VAN_OA.Dal.SysUserService();
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)
// {
// lblQuanXian.Text = "1";
// gvList.Columns[6].Visible = false;
// }
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getAllUserByLoginName("");
ddlContract_Brokerage.DataSource = user;
ddlContract_Brokerage.DataBind();
ddlContract_Brokerage.DataTextField = "LoginName";
ddlContract_Brokerage.DataValueField = "LoginName";
if (base.Request["Id"] != null)
{
this.btnAdd.Visible = false;
Contract model = this.contractSer.GetModel(Convert.ToInt32(base.Request["Id"]));
this.ddlContract_Type.Text = model.Contract_Type.ToString();
this.ddlContract_Use.Text = model.Contract_Use;
this.txtContract_No.Text = model.Contract_No;
this.txtContract_Unit.Text = model.Contract_Unit;
this.txtContract_Name.Text = model.Contract_Name;
this.txtContract_Summary.Text = model.Contract_Summary;
this.txtContract_Total.Text = model.Contract_Total.ToString();
this.txtContract_Date.Text = model.Contract_Date.ToString();
this.txtContract_PageCount.Text = model.Contract_PageCount.ToString();
this.txtContract_BCount.Text = model.Contract_BCount.ToString();
this.txtPONo.Text = model.PONo;
this.txtAE.Text = model.AE;
this.ddlContract_Brokerage.Text = model.Contract_Brokerage;
if (model.Contract_IsSign)
{
rabContract_IsSignB.Checked = true;
}
this.ddlContract_Local.Text = model.Contract_Local;
this.ddlContract_Year.Text = model.Contract_Year.ToString();
this.ddlContract_Month.Text = model.Contract_Month.ToString();
this.txtContract_Remark.Text = model.Contract_Remark;
txtContract_AllCount.Text = model.Contract_AllCount.ToString();
lblContract_ProNo.Text = model.Contract_ProNo;
cbContract_IsRequire.Checked = model.Contract_IsRequire;
if (model.Contract_IsRequire)
{
lbtnSelectPONo.Visible = false;
}
Contract_OldType.Value = model.Contract_Type.ToString();
}
else
{
this.btnUpdate.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.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";
List <Invoice> invoiceList = new List <Invoice>();
this.gvList.DataSource = invoiceList;
this.gvList.DataBind();
if (VAN_OA.JXC.SysObj.NewShowAll_textName("项目发票销帐", Session["currentUserId"], "销帐可编辑") == false)
{
ViewState["cbIsIsorder"] = false;
btnIsSelected.Visible = false;
gvList.Columns[0].Visible = false;
}
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
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";
if (Request["InvoiceNo"] != null)
{
txtInvoiceNo.Text = Request["InvoiceNo"].ToString();
Show();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
setBaiFenBi();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName("");
ddlAE.DataSource = user;
ddlAE.DataBind();
ddlAE.DataTextField = "LoginName";
ddlAE.DataValueField = "Id";
ddlINSIDE.DataSource = user;
ddlINSIDE.DataBind();
ddlINSIDE.DataTextField = "LoginName";
ddlINSIDE.DataValueField = "Id";
if (Request["type"] != null)
{
ddlAE.Enabled = true;
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
if (use.LoginName == "王鸣")
{
txtGuestName.ReadOnly = false;
}
}
if (base.Request["Id"] != null)
{
this.btnAdd.Visible = false;
ShowInfo(Convert.ToInt32(base.Request["Id"]));
}
else
{
int CreateUser = Convert.ToInt32(Session["currentUserId"]);
try
{
ddlAE.SelectedValue = CreateUser.ToString();
}
catch (Exception)
{
}
this.btnUpdate.Visible = false;
btnCopy.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName("");
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
A_ProInfoService proSer = new A_ProInfoService();
List <A_ProInfo> pros = proSer.GetListArray("");
ddlProType.DataSource = pros;
ddlProType.DataBind();
ddlProType.DataTextField = "pro_Type";
ddlProType.DataValueField = "pro_Id";
if (base.Request["ID"] != null)
{
cbAll.Visible = false;
this.btnAdd.Visible = false;
tb_ConsignorService conSer = new tb_ConsignorService();
tb_Consignor consi = conSer.GetListArray(" con_Id=" + base.Request["ID"])[0];
ddlProType.SelectedItem.Value = consi.proId.ToString();
if (consi.fromTime != null)
{
txtFrom.Text = Convert.ToDateTime(consi.fromTime).ToShortDateString();
}
if (consi.toTime != null)
{
txtTo.Text = Convert.ToDateTime(consi.toTime).ToShortDateString();
}
// txtconsignor.Text = consi.Consignor_Name;
cbYouXiao.Checked = consi.ifYouXiao;
ddlUser.Text = consi.consignor.ToString();
}
else
{
this.btnUpdate.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName("");
user.Insert(0, new VAN_OA.Model.User());
ddlAE.DataSource = user;
ddlAE.DataBind();
ddlAE.DataTextField = "LoginName";
ddlAE.DataValueField = "Id";
WebQuerySessin Sess = new WebQuerySessin(Query);
//加载SESSION中的数据
if (Session[Query] != null)
{
//QueryEForms
QuerySession.QueryGuestTrack QGuestTrack = Session[Query] as QuerySession.QueryGuestTrack;
if (QGuestTrack == null)
{
return;
}
if (QGuestTrack.FromTime != "")
{
txtFrom.Text = QGuestTrack.FromTime;
}
if (QGuestTrack.ToTime != "")
{
txtTo.Text = QGuestTrack.ToTime;
}
if (QGuestTrack.GuestName != "")
{
txtGuestName.Text = QGuestTrack.GuestName;
}
Show();
}
else
{
List <TB_GuestTrack> TB_GuestTracks = new List <TB_GuestTrack>();
this.gvList.DataSource = TB_GuestTracks;
this.gvList.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName("");
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName_ID";
ddlUser.DataValueField = "Id";
A_RoleService roleSer = new A_RoleService();
List <A_Role> roles = roleSer.GetModelList("");
this.ddlRoles.DataSource = roles;
this.ddlRoles.DataBind();
ddlRoles.DataTextField = "A_RoleName";
ddlRoles.DataValueField = "A_RoleId";
if (base.Request["ID"] != null)
{
this.btnAdd.Visible = false;
A_Role_User roleUser = roleUserSer.GetModelGetModel(Convert.ToInt32(base.Request["ID"]));
foreach (ListItem item in ddlRoles.Items)
{
if (item.Text == roleUser.RoleName)
{
item.Selected = true;
break;
}
}
//ddlRoles.SelectedItem.Text = roleUser.RoleName;
ddlUser.Text = roleUser.UserId.ToString();
cbAll.Visible = false;
txtRole_User_Index.Text = roleUser.Role_User_Index.ToString();
ddlRowState.Text = roleUser.RowState.ToString();
}
else
{
this.btnUpdate.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Dal.BaseInfo.TB_HouseInfoService houseSer = new VAN_OA.Dal.BaseInfo.TB_HouseInfoService();
List <Model.BaseInfo.TB_HouseInfo> houseList = houseSer.GetListArray("");
houseList.Insert(0, new VAN_OA.Model.BaseInfo.TB_HouseInfo());
ddlHouse.DataSource = houseList;
ddlHouse.DataBind();
ddlHouse.DataTextField = "houseName";
ddlHouse.DataValueField = "id";
//主单
List <SupplierToInvoiceView> pOOrderList = new List <SupplierToInvoiceView>();
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
this.gvAdvancePayment.DataSource = pOOrderList;
this.gvAdvancePayment.DataBind();
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getAllUserByLoginName("");
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = -1
});
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
ddlAdvUserList.DataSource = user;
ddlAdvUserList.DataBind();
ddlAdvUserList.DataTextField = "LoginName";
ddlAdvUserList.DataValueField = "Id";
if (Request["error"] != null)
{
txtSupplier.Text = Request["error"];
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交失败,供应商['" + Request["error"] + "']有在执行中的支付单，请排队等候');</script>");
}
}
}
protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e)
{
string where = "";
if (ddlCompany.Text != "-1")
{
where = string.Format(" and tb_User.CompanyCode =(select ComCode from TB_Company where id={0})", ddlCompany.Text);
}
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getAllUserByPOList(where);
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "选择", Id = -1
});
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
List <tb_OverTime> tb_OverServices = new List <tb_OverTime>();
this.gvList.DataSource = tb_OverServices;
this.gvList.DataBind();
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getAllUserByLoginName("");
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = -1
});
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
Session["Comm_CGPONo"] = null;
List <CG_POOrder> cars = new List <CG_POOrder>();
this.gvList.DataSource = cars;
this.gvList.DataBind();
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getAllUserByLoginName("");
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = -1
});
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bool showAll = true;
if (SysObj.IfShowAll("人事考核", Session["currentUserId"], "") == false)
{
ViewState["showAll"] = false;
showAll = false;
}
var user = new List <VAN_OA.Model.User>();
var userSer = new VAN_OA.Dal.SysUserService();
if (showAll == true)
{
user = userSer.getAllUserByLoginName("");
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = -1
});
}
else
{
var model = Session["userInfo"] as User;
user.Insert(0, model);
}
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
ds = new DataSet();
ds.Tables.Add(new DataTable());
ds.Tables.Add(new DataTable());
}
}
protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e)
{
string where = "";
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
if (ddlCompany.Text != "-1")
{
where = string.Format(" and tb_User.CompanyCode ='{0}'", ddlCompany.Text);
if (ViewState["WFScanDepartList"] != null && Convert.ToBoolean(ViewState["WFScanDepartList"]) == true)
{
where += string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]);
}
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getAllUserByPOList(where);
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "", Id = -1
});
}
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "LoginName";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
for (int i = 2012; i <= DateTime.Now.Year; i++)
{
ddlYear.Items.Add(new ListItem {
Value = i.ToString(), Text = i.ToString()
});
}
ddlYear.SelectedValue = (DateTime.Now.Year).ToString();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
List <VAN_OA.Model.User> user = userSer.getAllUserByPOList("");
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "LoginName";
if (base.Request["Id"] != null)
{
this.btnAdd.Visible = false;
AEPromiseTotal model = this.aEPromiseTotalService.GetModel(Convert.ToInt32(base.Request["Id"]));
ddlUser.Text = model.AE;
ddlYear.Text = model.YearNo.ToString();
txtAddGuestProfit.Text = model.AddGuestProfit.ToString();
txtAddGuetSellTotal.Text = model.AddGuetSellTotal.ToString();
txtPromiseProfit.Text = model.PromiseProfit.ToString();
txtPromiseSellTotal.Text = model.PromiseSellTotal.ToString();
}
else
{
this.btnUpdate.Visible = false;
}
}
}
protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e)
{
string where = "";
if (ddlCompany.Text != "-1")
{
where = string.Format(" and tb_User.CompanyCode ='{0}'", ddlCompany.Text.Split(',')[0]);
}
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
if (ddlUser.Text == "-1")//显示所有用户
{
}
else if (ddlUser.Text == "0")//显示部门信息
{
var model = Session["userInfo"] as User;
where += string.Format(" and loginIPosition='{0}' ", model.LoginIPosition);
}
else
{
var model = Session["userInfo"] as User;
where += string.Format(" and tb_User.ID={0}", model.Id);
}
user = userSer.getAllUserByPOList(where);
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = -1
});
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
List <WFAEPromiseTotal> _list = new List <WFAEPromiseTotal>();
this.gvList.DataSource = _list;
this.gvList.DataBind();
TB_CompanyService comSer = new TB_CompanyService();
var comList = comSer.GetListArray("");
comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
{
ComCode = "-1", ComName = "全部"
});
for (int i = 2012; i <= DateTime.Now.Year; i++)
{
ddlYear.Items.Add(new ListItem {
Value = i.ToString(), Text = i.ToString()
});
}
ddlYear.SelectedValue = (DateTime.Now.Year).ToString();
if (NewShowAll_textName("销售指标", "编辑") == false)
{
gvList.Columns[1].Visible = false;
btnAdd.Visible = false;
}
if (NewShowAll_textName("销售指标", "删除") == false)
{
gvList.Columns[2].Visible = false;
}
bool showAll = true;
if (NewShowAll_textName("销售指标", "查看所有"))
{
ViewState["showAll"] = false;
showAll = false;
}
bool WFScanDepartList = true;
if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("销售指标", Session["currentUserId"], "WFScanDepartList") == true)
{
ViewState["WFScanDepartList"] = false;
WFScanDepartList = false;
}
List <VAN_OA.Model.User> user = new List <User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
if (showAll == true)
{
user = userSer.getAllUserByPOList();
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = -1
});
}
else if (WFScanDepartList == true)
{
user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]));
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = 0
});
}
else
{
var model = Session["userInfo"] as User;
user.Insert(0, model);
ddlCompany.Enabled = false;
}
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "LoginName";
ddlCompany.DataSource = comList;
ddlCompany.DataBind();
}
}
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 <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 = "全部"
});
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";
//主单
List <JXC_REPORTTotal> pOOrderList = new List <JXC_REPORTTotal>();
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
bool showAll = true;
if (QuanXian_ShowAll("工程技术派工统计报表") == false)
{
ViewState["showAll"] = false;
showAll = false;
}
bool WFScanDepartList = true;
if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("工程技术派工统计报表", Session["currentUserId"], "WFScanDepartList") == true)
{
ViewState["WFScanDepartList"] = false;
WFScanDepartList = false;
}
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
if (showAll == true)
{
user = userSer.getAllUserByPOList();
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = -1
});
}
else if (WFScanDepartList == true)
{
user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]));
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = 0
});
}
else
{
var model = Session["userInfo"] as User;
user.Insert(0, model);
}
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("工程技术派工统计报表", "可导出"))
{
btnExcel.Visible = true;
}
else
{
btnExcel.Visible = false;
}
if (!NewShowAll_textName("工程技术派工统计报表", "编辑"))
{
gvMain.Columns[0].Visible = false;
}
string sql = string.Format("select loginName,ID from tb_User where loginIPosition='技术部' AND loginStatus='在职' and loginName<>'';");
List <User> getUsers = userSer.getUserReportTos(sql);
getUsers = getUsers.FindAll(T => string.IsNullOrEmpty(T.LoginName) == false);
getUsers.Insert(0, new Model.User {
Id = -1, LoginName = "全部"
});
getUsers.Add(new User {
Id = -1000, LoginName = "其他"
});
ddlPaiGong.DataSource = getUsers;
ddlPaiGong.DataBind();
ddlPaiGong.DataTextField = "LoginName";
ddlPaiGong.DataValueField = "Id";
if (Request["PONo"] != null)
{
txtPONo.Text = Request["PONo"].ToString();
ddlIsSpecial.Text = "-1";
Show();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
for (var i = 1; i < 100; i++)
{
ddlL_Month.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
}
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getAllUserByLoginName("");
ddlHandler.DataSource = user;
ddlHandler.DataBind();
ddlHandler.DataTextField = "LoginName";
ddlHandler.DataValueField = "LoginName";
if (base.Request["Id"] != null)
{
this.btnAdd.Visible = false;
Petitions model = this.petitionsSer.GetModel(Convert.ToInt32(base.Request["Id"]));
txtName.Text = model.Name;
this.ddlType.Text = model.Type;
this.lblNumber.Text = model.Number;
this.txtGuestName.Text = model.GuestName;
this.txtSalesUnit.Text = model.SalesUnit;
this.txtSummary.Text = model.Summary;
this.txtTotal.Text = model.Total.ToString();
this.txtSignDate.Text = model.SignDate.ToString();
this.txtSumPages.Text = model.SumPages.ToString();
this.txtSumCount.Text = model.SumCount.ToString();
this.txtBCount.Text = model.BCount.ToString();
this.txtPONo.Text = model.PoNo;
this.txtAE.Text = model.AE;
this.ddlHandler.Text = model.Handler;
this.ddlLocal.Text = model.Local;
this.ddlL_Year.Text = model.L_Year.ToString();
this.ddlL_Month.Text = model.L_Month.ToString();
this.txtRemark.Text = model.Remark;
cbIsRequire.Checked = model.IsRequire;
if (model.IsRequire)
{
lbtnSelectPONo.Visible = false;
}
if (model.IsColse)
{
rabIsColseB.Checked = true;
}
hfYear.Value = model.L_Year.ToString();
var supplierList = new CAI_POCaiService().GetLastSupplier(string.Format("'{0}'", model.PoNo));
txtSalesUnit.Text = string.Join(",", supplierList.Select(t => t.Supplier).ToArray());
txtTotal.Text = supplierList.Sum(t => t.Total).ToString();
}
else
{
ddlHandler.Text = "王汉中";
this.btnUpdate.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
btnReSet.Visible = false;
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName("");
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
Session["ProInvs"] = null;
gvList.Columns[0].Visible = false;
gvList.Columns[1].Visible = false;
btnSave.Enabled = false;
btnCancel.Enabled = false;
plProInvs.Visible = false;
btnEdit.Visible = false;
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
gvList.Columns[0].Visible = true;
gvList.Columns[1].Visible = true;
plProInvs.Visible = true;
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
//加载初始数据
List <Tb_ProjectInvs> proInvsList = new List <Tb_ProjectInvs>();
Session["ProInvs"] = proInvsList;
ViewState["ProInvsCount"] = proInvsList.Count;
gvList.DataSource = proInvsList;
gvList.DataBind();
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
ViewState["ProInvsIds"] = "";
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
Tb_ProjectInvService paProInvSer = new Tb_ProjectInvService();
Tb_ProjectInvsService sonProInvSer = new Tb_ProjectInvsService();
Tb_ProjectInv pProModel = paProInvSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtName.Text = pProModel.LoginName;
txtCreateTime.Text = pProModel.CreateTime.Value.ToString("yyyy-MM-dd");
txtProName.Text = pProModel.ProName;
txtProNo.Text = pProModel.ProNo;
ddlProState.Text = pProModel.State;
lblProInvState.Text = ddlProState.Text;
lblProNo.Text = pProModel.ProNo;
if (pProModel.State == "已完工")
{
lblProInvState.ForeColor = System.Drawing.Color.Red;
}
if (pProModel.State == "未完工")
{
}
try
{
ddlUser.SelectedValue = pProModel.GuestId.ToString();
}
catch (Exception)
{
}
List <Tb_ProjectInvs> proInvsList = sonProInvSer.GetListArray(" 1=1 and PId=" + Request["allE_id"]);
setTotal(proInvsList);
Session["ProInvs"] = proInvsList;
ViewState["ProInvsCount"] = proInvsList.Count;
gvList.DataSource = proInvsList;
gvList.DataBind();
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
btnReSet.Visible = true;
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
//判断是不是自己填写的单子
if (pProModel.UserId.ToString() == base.Session["currentUserId"].ToString())
{
gvList.Columns[0].Visible = true;
gvList.Columns[1].Visible = true;
btnEdit.Visible = true;
plProInvs.Visible = true;
setEnable(true);
}
}
}
}
}
}
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();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
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();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName("");
user.Insert(0, new VAN_OA.Model.User {
Id = -1, LoginName = "全部"
});
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
var aeUsers = userSer.getAllUserByPOList();
aeUsers.Insert(0, new VAN_OA.Model.User {
Id = -1, LoginName = "全部"
});
ddlAEUsers.DataSource = aeUsers;
ddlAEUsers.DataBind();
ddlAEUsers.DataTextField = "LoginName";
ddlAEUsers.DataValueField = "Id";
#region 是否有删除功能
if (Session["currentUserId"] != null)
{
VAN_OA.Dal.TB_AdminDeleteService deleteSer = new VAN_OA.Dal.TB_AdminDeleteService();
if (deleteSer.CheckIsExistByUserId(Convert.ToInt32(Session["currentUserId"])) == false)
{
gvList.Columns[1].Visible = false;
}
}
#endregion
WebQuerySessin Sess = new WebQuerySessin("QueryEForms");
gvList.PagerSettings.Mode = PagerButtons.NumericFirstLast;
A_ProInfoService proSer = new A_ProInfoService();
List <A_ProInfo> pros = this.proSer.GetListArray("");
pros.Insert(0, new A_ProInfo());
pros.Insert(pros.FindIndex(t => t.pro_Type == "销售发票"), new A_ProInfo {
pro_Id = -2, pro_Type = "销售发票+销售发票修改"
});
pros.Insert(pros.FindIndex(t => t.pro_Type == "销售发票") - 1, new A_ProInfo {
pro_Id = -3, pro_Type = "供应商付款单+供应商预付款单"
});
ddlProType.DataSource = pros;
ddlProType.DataBind();
ddlProType.DataTextField = "pro_Type";
ddlProType.DataValueField = "pro_Id";
//加载SESSION中的数据
if (Session["QueryEForms"] != null)
{
//QueryEForms
QuerySession.QueryEForm QEForm = Session["QueryEForms"] as QuerySession.QueryEForm;
if (QEForm == null)
{
return;
}
if (QEForm.ProTypeId != 0)
{
try
{
ddlProType.Text = QEForm.ProTypeId.ToString();
}
catch (Exception)
{
}
}
if (QEForm.FromTime != "")
{
txtFrom.Text = QEForm.FromTime;
}
if (QEForm.ToTime != "")
{
txtTo.Text = QEForm.ToTime;
}
if (QEForm.State != "")
{
ddlState.Text = QEForm.State;
}
if (QEForm.Apper != "")
{
foreach (ListItem m in ddlUser.Items)
{
if (m.Text == QEForm.Apper)
{
m.Selected = true;
break;
}
}
//ddlUser.SelectedItem.Text = QEForm.Apper;
}
if (QEForm.Auper != "")
{
txtAuper.Text = QEForm.Auper;
}
if (QEForm.WatingAuper != "")
{
txtWating.Text = QEForm.WatingAuper;
}
if (QEForm.E_No != "")
{
txtNo.Text = QEForm.E_No;
}
if (QEForm.PONO != "")
{
txtPONo.Text = QEForm.PONO;
}
if (QEForm.GuestName != "")
{
txtGuestName.Text = QEForm.GuestName;
}
txtSPForm.Text = QEForm.SPForm;
txtSPTo.Text = QEForm.SPTo;
select();
}
else
{
tb_EFormService eformSer = new tb_EFormService();
List <tb_EForm> allEForms = new List <tb_EForm>();// eformSer.GetListArray_1("");
this.gvList.DataSource = allEForms;
this.gvList.DataBind();
}
}
}
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 <JXC_REPORTTotal> pOOrderList = new List <JXC_REPORTTotal>();
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
//if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.JXC_REPORTTotalList, Session["currentUserId"]) == false)
//{
// ViewState["showAll"] = false;
//}
//System.Wen.HttpUtility.HtmlEncode.
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
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";
if (Request["PONo"] != null)
{
txtPONo.Text = Request["PONo"].ToString();
Show();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
TB_CompanyService comSer = new TB_CompanyService();
var comList = comSer.GetListArray("");
comList.Add(new VAN_OA.Model.BaseInfo.TB_Company()
{
ComName = "全部"
});
ddlCompany.DataSource = comList;
ddlCompany.DataBind();
if (Session["Company"] != null)
{
ddlCompany.Text = Session["Company"].ToString();
}
bool showAll = true;
if (QuanXian_ShowAll("报价单列表") == false)
{
ViewState["showAll"] = false;
showAll = false;
}
bool WFScanDepartList = true;
if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("报价单列表", Session["currentUserId"], "WFScanDepartList") == true)
{
ViewState["WFScanDepartList"] = false;
WFScanDepartList = false;
}
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
if (showAll == true)
{
user = userSer.getAllUserByPOList();
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = -1
});
}
else if (WFScanDepartList == true)
{
user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]));
user.Insert(0, new VAN_OA.Model.User()
{
LoginName = "全部", Id = 0
});
}
else
{
var model = Session["userInfo"] as User;
user.Insert(0, model);
}
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "Id";
if (Request["QuoteNo"] != null)
{
txtProno.Text = Request["QuoteNo"];
Show();
}
else
{
List <tb_QuotePrice> quotePriceList = new List <tb_QuotePrice>();
this.gvList.DataSource = quotePriceList;
this.gvList.DataBind();
}
}
}
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";
//加载基本信息
ddlNumber.Items.Add(new ListItem {
Text = "全部", Value = ""
});
ddlRow.Items.Add(new ListItem {
Text = "全部", Value = ""
});
ddlCol.Items.Add(new ListItem {
Text = "全部", Value = ""
});
//货架号：1.全部 缺省 2….51 1,..50
for (int i = 1; i < 51; i++)
{
ddlNumber.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
//层数：1.全部 缺省 2….21 1,2,3…20
//部位：1.全部 缺省 2….21 1,2,3…20
if (i <= 21)
{
ddlRow.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
ddlCol.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
}
}
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();
Dal.BaseInfo.TB_HouseInfoService houseSer = new VAN_OA.Dal.BaseInfo.TB_HouseInfoService();
List <Model.BaseInfo.TB_HouseInfo> houseList = houseSer.GetListArray("");
houseList.Insert(0, new VAN_OA.Model.BaseInfo.TB_HouseInfo());
ddlHouse.DataSource = houseList;
ddlHouse.DataBind();
ddlHouse.DataTextField = "houseName";
ddlHouse.DataValueField = "id";
//主单
List <CAI_OrderInHouse> pOOrderList = new List <CAI_OrderInHouse>();
this.gvMain.DataSource = pOOrderList;
this.gvMain.DataBind();
//子单
List <CAI_OrderInHouses> orders = new List <CAI_OrderInHouses>();
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();
if (QuanXian_ShowAll(SysObj.CAI_OrderInHouseList) == 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";
}
}
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";
if (Session["currentUserId"] != null)
{
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 <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)
{
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";
List <RuSellReport> list = new List <RuSellReport>();
gvMain.DataSource = list;
gvMain.DataBind();
if (Request["PONo"] != null)
{
txtPONo.Text = Request["PONo"].ToString();
ddlPoType.Text = "2";
cbRuZero.Checked = true;
Show();
}
if (Request["X"] != null)
{
Show();
}
}
}
}
