/// <summary>
/// 绑定部件序号
/// </summary>
/// <param name="array_xuhao"></param>
protected void BindPartXuhao(string[] array_xuhao)
{
int times = array_xuhao.Length - 2;
if (array_xuhao.Length > 3)
{
for (int i = 0; i < times; i++)
{
ddlXuhao.Items.Add(new ListItem(array_xuhao[i], array_xuhao[i]));
}
ddlXuhao.Items.Insert(0, new ListItem("-请选择-", "-请选择-"));
ddlXuhao.SelectedIndex = 0;
}
else
{
if (array_xuhao[0].Length > 3)//单一部件序号
{
ddlXuhao.Items.Add(new ListItem(array_xuhao[0], array_xuhao[0]));
ddlXuhao.Items.Insert(0, new ListItem("-请选择-", "-请选择-"));
ddlXuhao.SelectedIndex = 0;
}
else//顶级部件序号
{
string sqltext = "select BM_XUHAO,BM_XUHAO+'||'+BM_CHANAME as BM_CHANAME from " + strtable + " where BM_ENGID='" + ViewState["TaskId"].ToString() + "' AND (dbo.Splitnum(BM_XUHAO,'.')=1 or len(BM_XUHAO)=1) and BM_MSSTATE='0' order by dbo.f_formatstr(BM_XUHAO, '.')";
string dataText = "BM_CHANAME";
string dataValue = "BM_XUHAO";
DBCallCommon.BindAJAXCombox(ddlXuhao, sqltext, dataText, dataValue);
}
}
}
/// <summary>
/// 绑定项目名称
/// </summary>
protected void BindPjName()
{
string sqltext = "select distinct PS_PJID+'||'+PS_PJNAME as PS_PJNAME,PS_PJID from VIEW_TM_PAINTSCHEME where PS_STATE='8'";
string dataText = "PS_PJNAME";
string dataValue = "PS_PJID";
DBCallCommon.BindAJAXCombox(ddlProName, sqltext, dataText, dataValue);
}
/// <summary>
/// 绑定发运标志
/// </summary>
protected void GetFY()
{
string sql_text = "select distinct TSA_FY from View_TM_WorkAmount order by TSA_FY";
string dataText = "TSA_FY";
string dataVaue = "TSA_FY";
DBCallCommon.BindAJAXCombox(ddlFY, sql_text, dataText, dataVaue);
}
/// <summary>
/// 绑定设备名称
/// </summary>
protected void BindEngName()
{
string sql_eng = "select TSA_ID, TSA_ID+'|'+TSA_ENGNAME as TSA_ENGNAME from View_TM_TaskAssign where TSA_PJID='" + ddlProName.SelectedValue + "' order by TSA_ID";
string dataText = "TSA_ENGNAME";
string dataValue = "TSA_ID";
DBCallCommon.BindAJAXCombox(ddlEngName, sql_eng, dataText, dataValue);
}
/// <summary>
/// 绑定项目名称
/// </summary>
protected void BindProjName()
{
string sql_pj = "select distinct TSA_PJID,TSA_PJID+'|'+isnull(CM_PROJ,'') as PJ_NAME from View_TM_TaskAssign order by TSA_PJID desc";
string dataText = "PJ_NAME";
string dataValue = "TSA_PJID";
DBCallCommon.BindAJAXCombox(ddlProName, sql_pj, dataText, dataValue);
}
/// <summary>
/// 部件绑定
/// </summary>
private void GetddlNameData()
{
sqlText = "select BM_ZONGXU+'|'+BM_CHANAME AS BM_CHANAME,BM_ZONGXU from View_TM_DQO ";
sqlText += "where BM_ENGID='" + tsaid.Text + "' and (BM_MARID='' or BM_MARID is null) order by BM_CHANAME collate Chinese_PRC_CS_AS_KS_WS";
string dataText = "BM_CHANAME";
string dataValue = "BM_ZONGXU";
DBCallCommon.BindAJAXCombox(ddlbjname, sqlText, dataText, dataValue);
}
/// <summary>
/// 绑定年份
/// </summary>
protected void BindYear()
{
string sql = "select distinct (case when TSA_ADDTIME is null then '' else substring(TSA_ADDTIME,1,4)+'年' end) as YearText,(case when TSA_ADDTIME is null then '%' else substring(TSA_ADDTIME,1,4) end) as YearValue from View_TM_WorkAmount order by YearText";
string dataText = "YearText";
string dataValue = "YearValue";
DBCallCommon.BindAJAXCombox(ddlYear, sql, dataText, dataValue);
ddlYear.Items.RemoveAt(0);
ddlYear.Items.Insert(0, new ListItem("-年份-", "-年份-"));
ddlYear.SelectedIndex = 0;
}
/// <summary>
/// 绑定工程名称
/// </summary>
protected void BindEngName()
{
if (ddlProName.SelectedIndex != 0)
{
string sqltext = "select distinct PS_ENGID,PS_ENGID+'||'+PS_ENGNAME as PS_ENGNAME from VIEW_TM_PAINTSCHEME where PS_PJID='" + ddlProName.SelectedValue + "'";
string dataText = "PS_ENGNAME";
string dataValue = "PS_ENGID";
DBCallCommon.BindAJAXCombox(ddlEngName, sqltext, dataText, dataValue);
}
else
{
ddlEngName.Items.Clear();
ddlEngName.Items.Insert(0, new ListItem("-请选择-", "-请选择-"));
ddlEngName.SelectedIndex = 0;
}
}
/// <summary>
/// 绑定批号
/// </summary>
protected void BindLotNum()
{
StringBuilder strb = new StringBuilder();
strb.Append("select PS_ID from VIEW_TM_PAINTSCHEME where PS_STATE='8' ");
if (ddlProName.SelectedIndex != 0)
{
strb.Append(" and PS_PJID='" + ddlProName.SelectedValue + "'");
}
if (ddlEngName.SelectedIndex != 0)
{
strb.Append(" and PS_ENGID='" + ddlEngName.SelectedValue + "'");
}
string dataText = "PS_ID";
string dataValue = "PS_ID";
DBCallCommon.BindAJAXCombox(ddlLotNum, strb.ToString(), dataText, dataValue);
}
/// <summary>
/// 绑定技术员
/// </summary>
protected void GetTecName()
{
ddlTecName.Items.Clear();
StringBuilder str_sql = new StringBuilder();
str_sql.Append("select distinct TSA_TCCLERK,isnull(ST_NAMECODE,' ')+'||'+ST_NAME as ST_NAME from View_TM_WorkAmount where 1=1");
if (ddlProName.SelectedIndex != 0)
{
str_sql.Append("AND TSA_PJID='" + ddlProName.SelectedValue.ToString() + "'");
}
if (ddlEngName.SelectedIndex != 0)
{
str_sql.Append(" AND TSA_ID='" + ddlEngName.SelectedValue + "'");
}
string dataText = "ST_NAME";
string dataValue = "TSA_TCCLERK";
DBCallCommon.BindAJAXCombox(ddlTecName, str_sql.ToString(), dataText, dataValue);
}