protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
Labelstart.Text = Request.QueryString["liebie"];
//绑定
string no = Convert.ToString(Request.QueryString["no"]);
string condition = Convert.ToString(Request.QueryString["condition"]);
if (no == "1")
{
Grid_Detail.Columns[1].Visible = true;
Grid_Detail.Columns[2].Visible = false;
Grid_Detail.Columns[3].Visible = false;
Grid_Detail.DataSource = sd.S_SalesPerformance(no, "and CRMRBI_Name like '%" + condition.ToString() + "%'");
Grid_Detail.DataBind();
}
if (no == "2")
{
Grid_Detail.Columns[1].Visible = false;
Grid_Detail.Columns[2].Visible = true;
Grid_Detail.Columns[3].Visible = false;
Grid_Detail.DataSource = sd.S_SalesPerformance(no, "and CRMCIF_Name like '%" + condition.ToString() + "%'");
Grid_Detail.DataBind();
}
if (no == "3")
{
Grid_Detail.Columns[1].Visible = false;
Grid_Detail.Columns[2].Visible = false;
Grid_Detail.Columns[3].Visible = true;
Grid_Detail.DataSource = sd.S_SalesPerformance(no, "and CRMCIF_SalesMan like '%" + condition.ToString() + "%'");
Grid_Detail.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
Labelyear.Text = Request.QueryString["Year"];
//绑定
string Year = Request.QueryString["Year"];
string dep = Request.QueryString["dep"];
string post = Request.QueryString["post"];
string year = Year;
string condition = "";
if (dep != "请选择" && dep != "")
{
condition += "and a.部门 like '%" + dep + "%'";
if (post != "")
{
condition += "and a.岗位 like '%" + post + "%'";
}
}
Grid_Detail.DataSource = sd.S_QuitWorkAge(year, condition);
Grid_Detail.DataBind();
}
//Grid_Detail翻页
protected void Grid_Detail_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
if (-2 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = Grid_Detail.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox"); // refer to the TextBox with the NewPageIndex value
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex
}
}
else
{
newPageIndex = e.NewPageIndex;
}
string condition1 = GetCondition1();
string time = "BETWEEN '" + startime.Text.Trim() + "' AND '" + endtime.Text.Trim() + "'";
BindGrid_Detail(condition1, time);
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= Grid_Detail.PageCount ? Grid_Detail.PageCount - 1 : newPageIndex;
Grid_Detail.PageIndex = newPageIndex;
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
//下单时间
if (Request.QueryString["start"] == null || Request.QueryString["start"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["start"];
}
if (Request.QueryString["end"] == null || Request.QueryString["end"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["end"];
}
//绑定
DateTime start = Convert.ToDateTime(Request.QueryString["start"]);
DateTime end = Convert.ToDateTime(Request.QueryString["end"]);
Grid_Detail.DataSource = sd.S_ProductSum(start, end);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
//绑定
string CDA_EditionNO = Request.QueryString["CDA_EditionNO"];
string CDA_DocNO = Request.QueryString["CDA_DocNO"];
string CDA_DocName = Request.QueryString["CDA_DocName"];
string AllDep = Request.QueryString["CDA_AppDep"];
string laststar = Request.QueryString["laststar"];
string lastend = Request.QueryString["lastend"];
string condition = "";
string temp = "";
if (AllDep != "")
{
temp += " and AllDep like '%" + AllDep + "%'";
}
if (CDA_DocNO != "")
{
temp += " and CDA_DocNO like '%" + CDA_DocNO + "%'";
}
if (CDA_DocName != "")
{
temp += " and CDA_DocName like '%" + CDA_DocName + "%'";
}
if (CDA_EditionNO != "")
{
temp += " and CDA_EditionNO = '" + CDA_EditionNO + "'";
}
//生效时间
if (laststar != "" && lastend != "")
{
temp += " and CDA_EffectDate >= '" + laststar + "' and CDA_EffectDate <= '" + lastend + "'";
}
if (laststar != "" && lastend == "")
{
temp += " and CDA_EffectDate >= '" + laststar + "'";
}
if (laststar == "" && lastend != "")
{
temp += " and CDA_EffectDate <= '" + lastend + "'";
}
if (laststar == "" && lastend == "")
{
temp += "";
}
condition = temp;
Grid_Detail.DataSource = sd.S_ControlledDocAppHandout_Print(condition);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (Request.QueryString["startime"] == null || Request.QueryString["startime"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["startime"];
}
if (Request.QueryString["endtime"] == null || Request.QueryString["endtime"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["endtime"];
}
//绑定
string EI_No = Request.QueryString["EI_No"];
string EN_EquipName = Request.QueryString["EN_EquipName"];
string EMT_Type = Request.QueryString["EMT_Type"];
string startime = Request.QueryString["startime"];
string endtime = Request.QueryString["endtime"];
string condition1 = "";
string temp1 = "";
//if (startime != "" && endtime != "")
//{
// temp1 += " and ((EMA_CheckTime >= '" + startime + "' and EMA_CheckTime <= '" + endtime + "') or EMA_CheckTime is null) and ((ERDAOA_EndTime >= '" + startime + "' and ERDAOA_EndTime <= '" + endtime + "') or ERDAOA_EndTime is null)";
//}
if (EI_No != "")
{
temp1 += " and EI_No like '%" + EI_No + "%'";
}
if (EN_EquipName != "")
{
temp1 += " and EN_EquipName like '%" + EN_EquipName + "%'";
}
if (EMT_Type != "")
{
temp1 += " and EMT_Type like '%" + EMT_Type + "%'";
}
condition1 = temp1;
string time = "BETWEEN '" + startime + "' AND '" + endtime + "'";
Grid_Detail.DataSource = sd.S_EquipMaintenance_Statistical(condition1, time);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
Labelyear.Text = Request.QueryString["Year"];
//绑定
int Year = Convert.ToInt16(Request.QueryString["Year"]);
int year = Year;
Grid_Detail.DataSource = sd.S_QuitCountPercent(year);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "计件信息详情表打印";
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (Request.QueryString["startime"] == null || Request.QueryString["startime"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["startime"];
}
if (Request.QueryString["endtime"] == null || Request.QueryString["endtime"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["endtime"];
}
//绑定
string SPI_Name = Request.QueryString["SPI_Name"];
string PBC_Name = Request.QueryString["PBC_Name"];
string WO_Num = Request.QueryString["WO_Num"];
string startime = Request.QueryString["startime"];
string endtime = Request.QueryString["endtime"];
string HRDD_StaffNO = Request.QueryString["HRDD_StaffNO"];
string HRDD_Name = Request.QueryString["HRDD_Name"];
string BDOS_Name = Request.QueryString["BDOS_Name"];
string HRP_Post = Request.QueryString["HRP_Post"];
string condition = "";
condition += startime == "" ? " " : " and thedate >= '" + startime + "'";
condition += endtime == "" ? " " : " and thedate <= '" + endtime + "'";
condition += SPI_Name == "" ? " " : " and SPI_Name like '%" + SPI_Name + "%'";
condition += PBC_Name == "" ? " " : " and PBC_Name like '%" + PBC_Name + "%'";
condition += WO_Num == "" ? " " : " and WO_Num like '%" + WO_Num + "%'";
condition += HRDD_StaffNO == "" ? " " : " and HRDD_StaffNO like '%" + HRDD_StaffNO + "%'";
condition += HRDD_Name == "" ? " " : " and HRDD_Name like '%" + HRDD_Name + "%'";
condition += BDOS_Name == "" ? " " : " and BDOS_Name like '%" + BDOS_Name + "%'";
condition += HRP_Post == "" ? " " : " and HRP_Post like '%" + HRP_Post + "%'";
Grid_Detail.DataSource = Search_TimePerDayDetail(condition);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
//绑定
string HRDD_StaffNO = Request.QueryString["HRDD_StaffNO"];
string HRDD_Name = Request.QueryString["HRDD_Name"];
string HRET_EmpType = Request.QueryString["HRET_EmpType"];
string BDOS_Name = Request.QueryString["BDOS_Name"];
string HRP_Post = Request.QueryString["HRP_Post"];
string HRRewards_Type = Request.QueryString["HRRewards_Type"];
string HRRewards_Time1 = Request.QueryString["HRRewards_Time1"];
string HRRewards_Time2 = Request.QueryString["HRRewards_Time2"];
string HRRewards_Money = Request.QueryString["HRRewards_Money"];
string HRRewards_OkTime1 = Request.QueryString["HRRewards_OkTime1"];
string HRRewards_OkTime2 = Request.QueryString["HRRewards_OkTime2"];
string HRRewards_Agree = Request.QueryString["HRRewards_Agree"];
string HRRewards_Content = Request.QueryString["HRRewards_Content"];
string condition = "";
condition = HRDD_StaffNO == "" ? "" : " and HRDD_StaffNO like '%" + HRDD_StaffNO + "%'";
condition += HRDD_Name == "" ? "" : " and HRDD_Name like '%" + HRDD_Name + "%'";
condition += BDOS_Name == "" ? "" : " and b.BDOS_Code ='" + BDOS_Name + "'";
condition += HRP_Post == "" ? "" : " and a.HRP_ID ='" + HRP_Post + "'";
condition += HRET_EmpType == "" ? "" : " and a.HRET_ID ='" + HRET_EmpType + "'";
condition += HRRewards_Type == "" ? "" : " and HRRewards_Type ='" + HRRewards_Type + "'";
condition += HRRewards_Money == "" ? "" : " and HRRewards_Money = '" + HRRewards_Money + "'";
condition += HRRewards_Agree == "" ? "" : " and HRRewards_Agree like '%" + HRRewards_Agree + "%'";
condition += HRRewards_Content == "" ? "" : " and HRRewards_Content like '%" + HRRewards_Content + "%'";
condition += HRRewards_Time1 == "" ? "" : " and HRRewards_Time >= '" + HRRewards_Time1 + "'";
condition += HRRewards_Time2 == "" ? "" : " and HRRewards_Time <= '" + HRRewards_Time2 + "'";
condition += HRRewards_OkTime1 == "" ? "" : " and HRRewards_OkTime >= '" + HRRewards_OkTime1 + "'";
condition += HRRewards_OkTime2 == "" ? "" : " and HRRewards_OkTime <= '" + HRRewards_OkTime2 + "'";
try
{
Grid_Detail.DataSource = hRDDetailL.Search_HRDDetail_Type_Post_Senior(condition);
Grid_Detail.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
protected void Button2_Click(object sender, EventArgs e)
{
//ExcelHelper.GridViewToExcel(Grid_Detail, "计件信息详情表");
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=" + "计件信息详情表.xls");
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/vnd.ms-excel";
string strStyle = "<style>td{mso-number-format:\"\\@\";}</style>";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
stringWrite.WriteLine(strStyle);
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
Grid_Detail.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
}//员工考核项目得分列表的翻页
protected void Grid_Detail_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
if (-2 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = Grid_Detail.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox1"); // refer to the TextBox with the NewPageIndex value
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex
}
}
else
{
newPageIndex = e.NewPageIndex;
}
//Grid_Post.DataBind();
if (LblStateForGrid_Type.Text == "检索前")
{
//BindGridForEmployee(Grid_Detail, "");
BindGrid_Detail("");
}
if (LblStateForGrid_Type.Text == "检索后")
{
//BindGridForEmployee(Grid_Detail,"");
BindGrid_Detail(con1);
}
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= Grid_Detail.PageCount ? Grid_Detail.PageCount - 1 : newPageIndex;
Grid_Detail.PageIndex = newPageIndex;
Grid_Detail.PageIndex = newPageIndex;
Grid_Detail.DataBind();
}//员工考核总分列表的翻页
}//属于该账套的员工列表中的Gridview的删除
protected void Grid_Detail_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
if (-2 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = Grid_Detail.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox3"); // refer to the TextBox with the NewPageIndex value
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex
}
}
else
{
newPageIndex = e.NewPageIndex;
}
//Grid_Post.DataBind();
if (LabelForSearchEmployee.Text == "检索前")
{
BindGridForEmployee(Grid_Detail, " and HRPAT_ID='" + Label50.Text + "'");
}
if (LabelForSearchEmployee.Text == "检索后")
{
BindGridForEmployee(Grid_Detail, con1 + " and HRPAT_ID='" + Label50.Text + "'");
}
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= Grid_Detail.PageCount ? Grid_Detail.PageCount - 1 : newPageIndex;
Grid_Detail.PageIndex = newPageIndex;
Grid_Detail.PageIndex = newPageIndex;
Grid_Detail.DataBind();
}//员工列表的翻页
protected void Button2_Click(object sender, EventArgs e)
{
//string name = Labelyear.Text + "年" + Labelmonth.Text +"月" + Label13.Text + "(" + Label14.Text + ")薪资汇总表";
//ExcelHelper.GridViewToExcel(Grid_Detail, name);
Response.Clear();
//Response.AddHeader("content-disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(DateTime.Now.ToString("yyyy-MM-dd") + ".xls"));
Response.AddHeader("content-disposition", "attachment;filename=" + Labelyear.Text + "年" + Labelmonth.Text + "月" + Label13.Text + "(" + Label14.Text + ")薪资汇总表.xls");
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/vnd.ms-excel";
string strStyle = "<style>td{mso-number-format:\"\\@\";}</style>";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
stringWrite.WriteLine(strStyle);
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
Grid_Detail.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
Labelyear.Text = Request.QueryString["Year"];
//绑定
string Year = Request.QueryString["Year"];
string HRDD_StaffNO = Request.QueryString["HRDD_StaffNO"];
string HRDD_Name = Request.QueryString["HRDD_Name"];
string BDOS_Name = Request.QueryString["BDOS_Name"];
string HRP_Post = Request.QueryString["HRP_Post"];
string condition = "";
string temp = "";
if (Year != "")
{
temp += " and f.HRP_Year = '" + Year + "'";
}
if (HRDD_StaffNO != "")
{
temp += " and a.HRDD_StaffNO like '%" + HRDD_StaffNO + "%'";
}
if (HRDD_Name != "")
{
temp += " and a.HRDD_Name like '%" + HRDD_Name + "%'";
}
if (BDOS_Name != "")
{
temp += " and BDOS_Name like '%" + BDOS_Name + "%'";
}
if (HRP_Post != "")
{
temp += " and HRP_Post like '%" + HRP_Post + "%'";
}
condition = temp;
Grid_Detail.DataSource = sd.S_PerformceDetail(condition);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (Request.QueryString["startime"] == null || Request.QueryString["startime"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["startime"];
}
if (Request.QueryString["endtime"] == null || Request.QueryString["endtime"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["endtime"];
}
//绑定
string EN_EquipName = Request.QueryString["EN_EquipName"];
string startime = Request.QueryString["startime"];
string endtime = Request.QueryString["endtime"];
string condition1 = "";
string temp1 = "";
if (EN_EquipName != "")
{
temp1 += " and EN_EquipName like '%" + EN_EquipName + "%'";
}
condition1 = temp1;
string time = "BETWEEN '" + startime + "' AND '" + endtime + "'";
Grid_Detail.DataSource = sd.S_EquipMaintenance_TotalStatistical(condition1, time);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
Labelyear.Text = Request.QueryString["Year"];
//绑定
string Year = Request.QueryString["Year"];
string EN_EquipName = Request.QueryString["EN_EquipName"];
string condition = "";
string temp = "";
if (EN_EquipName != "")
{
temp += " and EN_EquipName like '%" + EN_EquipName + "%'";
}
condition = temp;
string year = Year;
Grid_Detail.DataSource = sd.S_Equiptrend(condition, year);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "计件信息阶段统计表打印";
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (Request.QueryString["startime"] == null || Request.QueryString["startime"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["startime"];
}
if (Request.QueryString["endtime"] == null || Request.QueryString["endtime"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["endtime"];
}
//绑定
string SPI_Name = Request.QueryString["SPI_Name"];
string PBC_Name = Request.QueryString["PBC_Name"];
string startime = Request.QueryString["startime"];
string endtime = Request.QueryString["endtime"];
string condition = "";
condition += startime == "" ? " " : " and thedate >= '" + startime + "'";
condition += endtime == "" ? " " : " and thedate <= '" + endtime + "'";
condition += SPI_Name == "" ? " " : " and SPI_Name like '%" + SPI_Name + "%'";
condition += PBC_Name == "" ? " " : " and PBC_Name like '%" + PBC_Name + "%'";
Grid_Detail.DataSource = Search_PieceTotal(condition);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (Request.QueryString["startime"] == null || Request.QueryString["startime"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["startime"];
}
if (Request.QueryString["endtime"] == null || Request.QueryString["endtime"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["endtime"];
}
//绑定
string CRMCIF_Name = Request.QueryString["CRMCIF_Name"];
string CRMCS_Name = Request.QueryString["CRMCS_Name"];
string CRMASS_Name = Request.QueryString["CRMASS_Name"];
string startime = Request.QueryString["startime"];
string endtime = Request.QueryString["endtime"];
string condition = "";
string temp = "";
if (CRMCIF_Name != "")
{
temp += " and CRMCIF_Name like '%" + CRMCIF_Name + "%'";
}
if (CRMCS_Name != "")
{
temp += " and CRMCS_Name = '" + CRMCS_Name + "'";
}
if (CRMASS_Name != "")
{
temp += " and CRMASS_Name = '" + CRMASS_Name + "'";
}
//投诉时间
if (startime != "" && endtime != "")
{
temp += " and CRMCCM_InputTime >= '" + startime + "' and CRMCCM_InputTime <= '" + endtime + "'";
}
if (startime != "" && endtime == "")
{
temp += " and CRMCCM_InputTime >= '" + startime + "'";
}
if (startime == "" && endtime != "")
{
temp += " and CRMCCM_InputTime <= '" + endtime + "'";
}
if (startime == "" && endtime == "")
{
temp += "";
}
condition = temp;
Grid_Detail.DataSource = sd.S_CustomerComplain(condition);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
//下单时间
if (Request.QueryString["TextBox6"] == null || Request.QueryString["TextBox6"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["TextBox6"];
}
if (Request.QueryString["TextBox7"] == null || Request.QueryString["TextBox7"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["TextBox7"];
}
//交货时间
if (Request.QueryString["TextBox8"] == null || Request.QueryString["TextBox8"] == "")
{
Label9.Text = "始";
}
else
{
Label9.Text = Request.QueryString["TextBox8"];
}
if (Request.QueryString["TextBox9"] == null || Request.QueryString["TextBox9"] == "")
{
Label11.Text = "今";
}
else
{
Label11.Text = Request.QueryString["TextBox9"];
}
//绑定
string CRMCIF_Name = Request.QueryString["CRMCIF_Name"];
string SMSO_ComOrderNum = Request.QueryString["SMSO_ComOrderNum"];
string SMSO_CusOrderNum = Request.QueryString["SMSO_CusOrderNum"];
string PT_Name = Request.QueryString["PT_Name"];
string SMSOD_DelCondition = Request.QueryString["SMSOD_DelCondition"];
string TextBox6 = Request.QueryString["TextBox6"];
string TextBox7 = Request.QueryString["TextBox7"];
string TextBox8 = Request.QueryString["TextBox8"];
string TextBox9 = Request.QueryString["TextBox9"];
string condition = "";
string temp = "";
if (CRMCIF_Name != "")
{
temp += " and CRMCIF_Name like '%" + CRMCIF_Name + "%'";
}
if (SMSO_ComOrderNum != "")
{
temp += " and SMSO_ComOrderNum like '%" + SMSO_ComOrderNum + "%'";
}
if (SMSO_CusOrderNum != "")
{
temp += " and SMSO_CusOrderNum like '%" + SMSO_CusOrderNum + "%'";
}
if (PT_Name != "")
{
temp += " and PT_Name like '%" + PT_Name + "%'";
}
if (SMSOD_DelCondition != "")
{
temp += " and SMSOD_DelCondition like '%" + SMSOD_DelCondition + "%'";
}
//下单时间
if (TextBox6 != "" && TextBox7 != "")
{
temp += " and SMSO_PlaceOrderTime >= '" + TextBox6 + "' and SMSO_PlaceOrderTime <= '" + TextBox7 + "'";
}
if (TextBox6 != "" && TextBox7 == "")
{
temp += " and SMSO_PlaceOrderTime >= '" + TextBox6 + "'";
}
if (TextBox6 == "" && TextBox7 != "")
{
temp += " and SMSO_PlaceOrderTime <= '" + TextBox7 + "'";
}
if (TextBox6 == "" && TextBox7 == "")
{
temp += "";
}
//交货时间
if (TextBox8 != "" && TextBox9 != "")
{
temp += " and SMOD_Time >= '" + TextBox8 + "' and SMOD_Time <= '" + TextBox9 + "'";
}
if (TextBox8 != "" && TextBox9 == "")
{
temp += " and SMOD_Time >= '" + TextBox8 + "'";
}
if (TextBox8 == "" && TextBox9 != "")
{
temp += " and SMOD_Time <= '" + TextBox9 + "'";
}
if (TextBox8 == "" && TextBox9 == "")
{
temp += "";
}
condition = temp;
Grid_Detail.DataSource = sd.S_SalesOrderFinish(condition);
Grid_Detail.DataBind();
}
private void BindGrid_Detail(string condition1, string time)
{
Grid_Detail.DataSource = sd.S_EquipOutput_Statistical(condition1, time);
Grid_Detail.DataBind();
}
//绑定
private void BindGrid_Detail(string condition)
{
Grid_Detail.DataSource = sd.S_SMDetailReport_shd(condition);
Grid_Detail.DataBind();
}
//绑定
private void BindGrid_Detail(string condition)
{
Grid_Detail.DataSource = sd.S_Chanliang(condition);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
//绑定
string SDBT_NO = Request.QueryString["SDBT_NO"];
string SDBT_Name = Request.QueryString["SDBT_Name"];
string SDBT_Dep = Request.QueryString["SDBT_Dep"];
string SDBT_Post = Request.QueryString["SDBT_Post"];
string SDBT_Year = Request.QueryString["SDBT_Year"];
string SDBT_Month = Request.QueryString["SDBT_Month"];
Labelyear.Text = SDBT_Year;
Labelmonth.Text = SDBT_Month;
if (SDBT_Dep == "")
{
Label13.Text = "所有部门";
}
else
{
Label13.Text = SDBT_Dep;
}
if (SDBT_Post == "")
{
Label14.Text = "所有岗位";
}
else
{
Label14.Text = SDBT_Post;
}
string condition = "";
string temp = "";
if (SDBT_NO != "")
{
temp += " and SDBT_NO like '%" + SDBT_NO + "%'";
}
if (SDBT_Name != "")
{
temp += " and SDBT_Name like '%" + SDBT_Name + "%'";
}
if (SDBT_Dep != "")
{
temp += " and SDBT_Dep like '%" + SDBT_Dep + "%'";
}
if (SDBT_Post != "")
{
temp += " and SDBT_Post like '%" + SDBT_Post + "%'";
}
if (SDBT_Year != "")
{
temp += " and SDBT_Year = '" + SDBT_Year + "'";
}
if (SDBT_Month != "")
{
temp += " and SDBT_Month = '" + SDBT_Month + "'";
}
condition = temp;
Grid_Detail.DataSource = sd.S_SalaryDetailEachMonth(condition);
Grid_Detail.DataBind();
}
//绑定
private void BindGrid_Detail(string condition)
{
Grid_Detail.DataSource = sd.S_SalaryDetailEachMonth(condition);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (Request.QueryString["startime"] == null || Request.QueryString["startime"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["startime"];
}
if (Request.QueryString["endtime"] == null || Request.QueryString["endtime"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["endtime"];
}
//绑定
string PBC_Name = Request.QueryString["PBC_Name"];
string SPS_Name = Request.QueryString["SPS_Name"];
string SPI_Name = Request.QueryString["SPI_Name"];
string startime = Request.QueryString["startime"];
string endtime = Request.QueryString["endtime"];
string condition = "";
string temp = "";
if (PBC_Name != "")
{
temp += " and PBC_Name like '%" + PBC_Name + "%'";
}
if (SPS_Name != "")
{
temp += " and SPS_Name like '%" + SPS_Name + "%'";
}
if (SPI_Name != "")
{
temp += " and SPI_Name like '%" + SPI_Name + "%'";
}
//时间
if (startime != "" && endtime != "")
{
temp += " and SPICR_ExecDate >= '" + startime + "' and SPICR_ExecDate <= '" + endtime + "'";
}
if (startime != "" && endtime == "")
{
temp += " and SPICR_ExecDate >= '" + startime + "'";
}
if (startime == "" && endtime != "")
{
temp += " and SPICR_ExecDate <= '" + endtime + "'";
}
if (startime == "" && endtime == "")
{
temp += "";
}
condition = temp;
Grid_Detail.DataSource = sd.S_PieceChage(condition);
Grid_Detail.DataBind();
}
//绑定
private void BindGrid_Detail(string condition)
{
Grid_Detail.DataSource = sd.S_PersonnelSalaryRecord(condition);
Grid_Detail.DataBind();
}
//绑定
private void BindGrid_Detail(string condition)
{
Grid_Detail.DataSource = sd.S_PieceChage(condition);
Grid_Detail.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (Request.QueryString["CDA_AppDep"] == null || Request.QueryString["CDA_AppDep"] == "")
{
AppDep.Text = "全部";
}
else
{
AppDep.Text = Request.QueryString["CDA_AppDep"];
}
//绑定
string CDA_AppDep = Request.QueryString["CDA_AppDep"];
string CDA_DocNO = Request.QueryString["CDA_DocNO"];
string CDA_DocName = Request.QueryString["CDA_DocName"];
string laststar = Request.QueryString["laststar"];
string lastend = Request.QueryString["lastend"];
string neweststar = Request.QueryString["neweststar"];
string newestend = Request.QueryString["newestend"];
string condition = "";
string temp = "";
if (CDA_AppDep != "")
{
temp += " and a.CDA_AppDep = '" + CDA_AppDep + "'";
}
if (CDA_DocNO != "")
{
temp += " and a.CDA_DocNO like '%" + CDA_DocNO + "%'";
}
if (CDA_DocName != "")
{
temp += " and a.CDA_DocName like '%" + CDA_DocName + "%'";
}
//上次版本生效时间
if (laststar != "" && lastend != "")
{
temp += " and b.CDA_EffectDate >= '" + laststar + "' and b.CDA_EffectDate <= '" + lastend + "'";
}
if (laststar != "" && lastend == "")
{
temp += " and b.CDA_EffectDate >= '" + laststar + "'";
}
if (laststar == "" && lastend != "")
{
temp += " and b.CDA_EffectDate <= '" + lastend + "'";
}
if (laststar == "" && lastend == "")
{
temp += "";
}
//最新版本生效时间
if (neweststar != "" && newestend != "")
{
temp += " and a.CDA_EffectDate >= '" + neweststar + "' and a.CDA_EffectDate <= '" + newestend + "'";
}
if (neweststar != "" && newestend == "")
{
temp += " and a.CDA_EffectDate >= '" + neweststar + "'";
}
if (neweststar == "" && newestend != "")
{
temp += " and a.CDA_EffectDate <= '" + newestend + "'";
}
if (neweststar == "" && newestend == "")
{
temp += "";
}
condition = temp;
Grid_Detail.DataSource = sd.S_ControlledDocApp_Print(condition);
Grid_Detail.DataBind();
}
//绑定
private void BindGrid_Detail(string condition)
{
Grid_Detail.DataSource = sd.S_EquipSpare_Statistical(condition);
Grid_Detail.DataBind();
}
}//
private void BindGrid_Detail(string condition)
{
Grid_Detail.DataSource = Search_TimePerDayDetail(condition);
Grid_Detail.DataBind();
}
