//绑定调入部门和调出部门
protected void bind_ddl()
{
string sqltext_dep = "select distinct DEP_NAME,DEP_CODE from TBDS_DEPINFO where DEP_CODE LIKE '[0-9][0-9]'";
DBCallCommon.FillDroplist(ddl_MOVE_OUTPART, sqltext_dep);
DBCallCommon.FillDroplist(ddl_MOVE_INPART, sqltext_dep);
}
protected void bind_ddl()
{
Encrypt_Decrypt ed = new Encrypt_Decrypt();
ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString());
lbl_con.Text = ContractNo;
string sql_title = "select PCON_ENGNAME,PCON_ENGTYPE from TBPM_CONPCHSINFO where PCON_BCODE='" + ContractNo + "' ";
System.Data.DataTable dt_title = DBCallCommon.GetDTUsingSqlText(sql_title);
if (dt_title.Rows.Count > 0)
{
lbl_project.Text = dt_title.Rows[0][0].ToString().Trim();
lbl_engineer.Text = dt_title.Rows[0][1].ToString().Trim();
}
//string type = (ViewState["type"].ToString() == "1" ? " and [YS_XS_Finished] ='1'" : " and YS_XS_Finished is null");
//string sqltext_people = "select distinct YS_ADDNAME,YS_ADDNAME from View_YS_COST_BUDGET_REAL where 1=1 " +type;
//string sqltext_PJ = "SELECT DISTINCT PCON_PJNAME ,PCON_PJNAME FROM View_YS_COST_BUDGET_REAL where 1=1" +type;
//string sqltext_ENG = "SELECT DISTINCT PCON_ENGNAME,PCON_ENGNAME FROM View_YS_COST_BUDGET_REAL where 1=1" +type;
string sqltext_EQ = "SELECT PCON_EQNAME,PCON_EQNAME FROM View_YS_COST_BUDGET_REAL where 1=1 and YS_CONTRACT_NO='" + ContractNo + "' ";
//DBCallCommon.FillDroplist(dpl_people, sqltext_people);
//DBCallCommon.FillDroplist(ddl_project, sqltext_PJ);
//DBCallCommon.FillDroplist(ddl_engineer, sqltext_ENG);
DBCallCommon.FillDroplist(ddl_task, sqltext_EQ);
}
protected void bind_ddl()
{
//string sqltext_people = "select distinct YS_ADDNAME,YS_ADDNAME from View_YS_CON_BUDGET_REAL where 1=1 " + type;
string sqltext_PJ = "SELECT DISTINCT PCON_PJNAME ,PCON_PJNAME FROM View_YS_CON_BUDGET_REAL where 1=1 and YS_XS_Finished='0'";
string sqltext_ENG = "SELECT DISTINCT PCON_ENGNAME,PCON_ENGNAME FROM View_YS_CON_BUDGET_REAL where 1=1 and YS_XS_Finished='0'";
//DBCallCommon.FillDroplist(dpl_people, sqltext_people);
DBCallCommon.FillDroplist(ddl_project, sqltext_PJ);
DBCallCommon.FillDroplist(ddl_engineer, sqltext_ENG);
}
protected void Page_Load(object sender, EventArgs e)
{
string sqltxt = "";
InitVar();
if (!IsPostBack)
{
ddlSearchchild.Visible = false;
sqltxt = "select distinct CL_NAME,CL_CODE from TBCS_LOCINFO where CL_FATHERCODE='ROOT'";
DBCallCommon.FillDroplist(ddlSearch, sqltxt);
selectaddgroupd.SelectedIndex = 0;
bindGrid();
}
CheckUser(ControlFinder);
}
protected void GridViewSearch_DataBound(object sender, EventArgs e)
{
foreach (GridViewRow gr in GridViewSearch.Rows)
{
if (ddlType.SelectedValue == "03")
{
DropDownList ddl = (gr.FindControl("DropDownListName") as DropDownList);
ddl.DataTextField = "value";
ddl.DataValueField = "key";
ddl.DataSource = bindThreeList();
ddl.DataBind();
}
else
{
DropDownList ddl = (gr.FindControl("DropDownListName") as DropDownList);
ddl.DataTextField = "value";
ddl.DataValueField = "key";
DropDownList ddlTypeValue = (gr.FindControl("ddlTypeValue") as DropDownList);
if (ddlType.SelectedValue == "02")
{
ddl.DataSource = bindTwoList();
ddl.DataBind();
string sql = "select ty_name,TY_ID from TBMA_typeinfo where ty_fatherid !='ROOT'";
DBCallCommon.FillDroplist(ddlTypeValue, sql);
}
else
{
ddl.DataSource = bindOneList();
ddl.DataBind();
ddlTypeValue.Items.Add(new ListItem("-请选择-", "-请选择-"));
ddlTypeValue.Items.Add(new ListItem("原材料", "01"));
ddlTypeValue.Items.Add(new ListItem("低值易耗品", "02"));
}
}
if (gr.RowIndex == 4)
{
(gr.FindControl("tb_logic") as System.Web.UI.WebControls.TextBox).Visible = false;
}
}
}
protected void ddlSearch_SelectedIndexChanged(object sender, EventArgs e)
{
string ddlvalue = "";
if (ddlSearch.SelectedItem.Text.Trim() == "-请选择-")
{
ddlSearchchild.Visible = false;
bindGrid();
}
else
{
ddlSearchchild.Visible = true;
ddlvalue = ddlSearch.SelectedItem.Value.ToString();
sqlText = "select distinct CL_NAME,CL_CODE from TBCS_LOCINFO where CL_FATHERCODE='" + ddlvalue + "' ";
//Response.Write(ddlvalue);
//Response.End();
DBCallCommon.FillDroplist(ddlSearchchild, sqlText);
RebindGrid();
}
}
protected void bind_ddl()
{
string sqltext_PJ = "SELECT DISTINCT PCON_PJNAME ,PCON_PJNAME FROM View_YS_COST_BUDGET_REAL where 1=1";
string sqltext_ENG = "SELECT DISTINCT PCON_ENGNAME,PCON_ENGNAME FROM View_YS_COST_BUDGET_REAL where 1=1";
DBCallCommon.FillDroplist(ddl_project, sqltext_PJ);
DBCallCommon.FillDroplist(ddl_engineer, sqltext_ENG);
string sql_updatetime = "select top 1 YS_UPDATE_TIME from YS_COST_BUDGET_ORDER order by YS_UPDATE_TIME desc";
System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sql_updatetime);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() != "")
{
DateTime time = Convert.ToDateTime(dt.Rows[0][0].ToString());
lab_updatetime.Text = time.ToString("yyyy-MM-dd HH:mm");
}
}
else
{
lab_updatetime.Text = "未更新";
}
}
protected void bind_ddl()
{
string type = (ViewState["type"].ToString() == "1" ? " and [YS_XS_Finished] ='1'" : " and YS_XS_Finished != '0'");
//string sqltext_people = "select distinct YS_ADDNAME,YS_ADDNAME from View_YS_CON_BUDGET_REAL where 1=1 " + type;
string sqltext_PJ = "SELECT DISTINCT PCON_PJNAME ,PCON_PJNAME FROM View_YS_CON_BUDGET_REAL where 1=1" + type;
string sqltext_ENG = "SELECT DISTINCT PCON_ENGNAME,PCON_ENGNAME FROM View_YS_CON_BUDGET_REAL where 1=1" + type;
if (ViewState["type"].ToString() == "1")
{
//btnModify.Visible = false;
//btnShowSta.Visible = false;
LabelTitle.Text = "合同预算分析";
}
else
{
//btnModify.Visible = true;
//btnShowSta.Visible = false;
LabelTitle.Text = "合同预算监控";
}
//DBCallCommon.FillDroplist(dpl_people, sqltext_people);
DBCallCommon.FillDroplist(ddl_project, sqltext_PJ);
DBCallCommon.FillDroplist(ddl_engineer, sqltext_ENG);
}
//protected string check_ddl_YS()
//{
// Encrypt_Decrypt ed = new Encrypt_Decrypt();
// string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString());
// string Mar_code = Request.QueryString["Marcode"].ToString();
// string str_ys_name = "";
// if (Mar_code=="01.07")
// {
// if (ddl_YS_name.SelectedItem.Text.ToString()=="定尺板")
// {
// if (DropDownList_mar_type.SelectedItem.Text.ToString()!="定尺板")
// {
// str_ys_name = " and PO_MASHAPE='定尺板'";
// }
// }
// else
// if (ddl_YS_name.SelectedItem.Text.ToString() == "轨道系统")
// {
// str_ys_name = " and marnm like '%轨道%'";
// }
// else if (ddl_YS_name.SelectedItem.Text.ToString() == "普通材料")
// {
// str_ys_name = " and charindex('轨道',marnm)=0 and PO_MASHAPE!='定尺板'";
// }
// }
// if (Mar_code=="01.11"||Mar_code=="01.08")
// {
// str_ys_name = " and charindex('" + ddl_YS_name.SelectedItem.Text.ToString() + "',marnm)>0 ";
// string sql_contain = "select YS_Product_Name from TBBD_Product_type where YS_Product_Tag='1' " +
// "and charindex('-',YS_Product_Code)>0 and YS_Product_Name like '%" + ddl_YS_name.SelectedItem.Text.ToString() + "%' " +
// "and YS_Product_Name!='" + ddl_YS_name.SelectedItem.Text.ToString() + "'";
// System.Data.DataTable dt_contain = DBCallCommon.GetDTUsingSqlText(sql_contain);
// for (int s = 0; s < dt_contain.Rows.Count; s++)
// {
// str_ys_name += " and charindex('" + dt_contain.Rows[s]["YS_Product_Name"] + "',marnm)=0";
// }
// }
// if (Mar_code=="other")
// {
// string sql_mar_type = "select YS_Product_Code from TBBD_Product_type where YS_Product_Name='" + ddl_YS_name.SelectedItem.Text.ToString() + "'";
// System.Data.DataTable dt_mar_type = DBCallCommon.GetDTUsingSqlText(sql_mar_type);
// if (dt_mar_type.Rows.Count > 0)
// {
// str_ys_name += " and marid like '" + dt_mar_type.Rows[0][0].ToString() + "%'";
// }
// }
// return str_ys_name;
//}
//protected void bind_ddl_YSname()
//{
// Encrypt_Decrypt ed = new Encrypt_Decrypt();
// string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString());
// string Mar_code = Request.QueryString["Marcode"].ToString();
// string name_type = "";
// switch (Mar_code)
// {
// case "01.07": name_type = "FERROUS_METAL"; break;
// case "01.11": name_type = "PURCHASE_PART"; break;
// case "01.08": name_type = "MACHINING_PART"; break;
// case "01.15": name_type = "PAINT_COATING"; break;
// case "01.18": name_type = "ELECTRICAL"; break;
// case "other": name_type = "OTHERMAT_COST"; break;
// default: break;
// }
// string sql_YS_NAME = "select distinct YS_NAME,YS_NAME from YS_COST_BUDGET_DETAIL where YS_CONTRACT_NO='" + ContractNo + "' and YS_FATHER='" + name_type + "' and YS_NAME!='其它'";
// DBCallCommon.FillDroplist(ddl_YS_name, sql_YS_NAME);
//}
protected void bind_ddl_mar()
{
Encrypt_Decrypt ed = new Encrypt_Decrypt();
string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString());
string Mar_code = Request.QueryString["Marcode"].ToString();
switch (Mar_code)
{
case "01.07": YS_NAME.Text = "黑色金属"; break;
case "01.11": YS_NAME.Text = "外购件"; break;
case "01.08": YS_NAME.Text = "加工件"; break;
case "01.15": YS_NAME.Text = "油漆涂料"; break;
case "01.18": YS_NAME.Text = "电气电料"; break;
case "other": YS_NAME.Text = "其他材料费"; break;
default: break;
}
string sql_where = " engid='" + ContractNo + "'";
//获取材料ID
if (Mar_code != "other")
{
sql_where += " and marid like '" + Mar_code + "%'";
}
else
{
sql_where += " and charindex(substring(marid,1,5),'01.07.01.08.01.11.01.15.01.18')=0";
}
string sqltext_mar_type = "SELECT DISTINCT isnull(PO_MASHAPE,'无') ,PO_MASHAPE FROM View_TBPC_PURORDERDETAIL_PLAN_TOTAL where " + sql_where;
DBCallCommon.FillDroplist(DropDownList_mar_type, sqltext_mar_type);
}
