/// <summary>
/// 勾选项导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExportCheck_OnClick(object sender, EventArgs e)
{
string array_lotnum = "";
foreach (GridViewRow grow in GridView1.Rows)
{
CheckBox ckb = (CheckBox)grow.FindControl("CheckBox1");
if (ckb.Checked)
{
array_lotnum += "'" + grow.Cells[1].Text.Trim() + "',";
}
}
if (array_lotnum == "")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请勾选要导出的批号！！！');", true);
}
else if (array_lotnum.Split(',').Length > 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请逐条勾导出！！！');", true);
}
else
{
array_lotnum = array_lotnum.Substring(0, array_lotnum.Length - 1);
ExportTMDataFromDB.ExportMSData(array_lotnum, array_lotnum.Split('.')[1]);
}
}
/// <summary>
/// 导出调整项Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExport_OnClick(object sender, EventArgs e)
{
string sqltext = "select [BM_MSXUHAO],[BM_XUHAO],[BM_TUHAO],[BM_MARID],[BM_ZONGXU],[BM_CHANAME],[BM_ENGSHNAME],[BM_GUIGE],[BM_MAQUALITY],[BM_NUMBER],[BM_UNITWGHT],[BM_TOTALWGHT],[BM_MASHAPE],[BM_MASTATE],[BM_PROCESS],[BM_KU],'' as BM_BOX,[BM_NOTE],[BM_STANDARD],[BM_ISMANU] from View_TM_DQO where " + ViewState["sqlText"].ToString() + " and BM_XUHAO NOT LIKE '%.0.%' order by dbo.f_formatstr(BM_XUHAO, '.')";
string pjname = proname.Text.Trim() + "(" + proname.Text + ")";
string engnanme = tsaid.Text.Trim().Split('-')[0] + "(" + engname.Text.Trim() + ")";
ExportTMDataFromDB.ExportNormalMSAdjust(sqltext, pjname, engnanme);
}
/// <summary>
/// 导出制作明细表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnMsExport_OnClick(object sender, EventArgs e)
{
if (ddlLotNumList.SelectedIndex != 0)
{
ExportTMDataFromDB.ExportMSData(ddlLotNumList.SelectedValue, tsaid.Text);
}
else
{
this.ClientScript.RegisterStartupScript(GetType(), "js", "alert('按批号导出,请选择批号！！！');self.close();", true);
}
}
/// <summary>
/// 导出制作明细
/// </summary>
/// <param name="seneder"></param>
/// <param name="e"></param>
protected void lnkBtnExport_OnClick(object seneder, EventArgs e)
{
if (ddlProName.SelectedIndex == 0 || ddlEngName.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择项目、设备！！！');", true);
}
else
{
ExportTMDataFromDB.ExportAllMsData(ddlEngName.SelectedValue);
}
}
/// <summary>
/// 导出Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lnkBtnExport_OnClick(object sender, EventArgs e)
{
if (ddlLotNum.SelectedIndex != 0)
{
ExportTMDataFromDB.ExportPSData(ddlLotNum.SelectedValue);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择要导出的批号！！！');", true);
}
}
protected void GridView1_OnPreRender(object sender, EventArgs e)
{
ExportTMDataFromDB.AbandonRepeatColumnCells(GridView1, 1);
ExportTMDataFromDB.AbandonRepeatColumnCells(GridView1, 5);
ExportTMDataFromDB.AbandonRepeatColumnCells(GridView1, 6);
ExportTMDataFromDB.AbandonRepeatColumnCells(GridView1, 7);
ExportTMDataFromDB.AbandonRepeatColumnCells(GridView1, 8);
ExportTMDataFromDB.AbandonRepeatColumnCells(GridView1, 9);
ExportTMDataFromDB.AbandonRepeatColumnCells(GridView1, 12);
ExportTMDataFromDB.AbandonRepeatColumnCells(GridView1, 14);
ExportTMDataFromDB.AbandonRepeatColumnCells(GridView1, 15);
}
/// <summary>
/// 导出材料计划Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lnkBtnExport_OnClick(object sender, EventArgs e)
{
if (ddlProName.SelectedIndex == 0 || ddlEngName.SelectedIndex == 0 || ddlMpOutType.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择项目、工程及提交类别！！！');", true);
return;
}
else
{
string str = "";
//查询项目
if (ddlProName.SelectedValue != "-请选择-")
{
str += " MP_PJID='" + ddlProName.SelectedValue + "' ";
}
//查询工程
if (ddlEngName.SelectedValue != "-请选择-")
{
str += " and dbo.GetNoEngid(MP_ENGID,'-')='" + ddlEngName.SelectedValue + "' ";
}
//提交类别
if (ddlMpOutType.SelectedValue != "-请选择-")
{
str += this.GetTypeQureyCondition(ddlMpOutType.SelectedValue);
}
DataTable dt;
if (ddlMpOutType.SelectedValue == "定尺板")
{
dt = GetDataByPagerQueryParam(str, "1", "1");
}
else
{
dt = GetDataByPagerQueryParam(str, "1", "0");
}
if (dt.Rows.Count > 0)
{
string[] aa = ddlProName.SelectedItem.Text.Split('‖');
string prj = aa[1] + "(" + aa[0] + ")";
string[] bb = ddlEngName.SelectedItem.Text.Split('‖');
string engname = bb[1];
string engid = bb[0];
ExportTMDataFromDB.ExportAllMpData(dt, prj, engid, engname, ddlMpOutType.SelectedValue);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('没有数据！！！');", true);
}
}
}
protected void btnExpotOrg_Click(object sender, EventArgs e)
{
string taskIDS = "";
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow grow = GridView1.Rows[i];
CheckBox cbx = (CheckBox)grow.FindControl("CheckBox1");
if (cbx.Checked)
{
taskIDS += grow.Cells[2].Text.Trim() + "/";
}
}
if (taskIDS == "" || taskIDS.Trim('/').Split('/').Count() > 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('提示:请勾选至少一条任务');", true);
}
else
{
ExportTMDataFromDB.ExportMsFromOrg(taskIDS.Trim('/'));
}
}
/// <summary>
/// 导出生产制号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lnkBtnExport_OnClick(object sender, EventArgs e)
{
string sql = "select TSA_ID,TSA_PJNAME+'('+TSA_PJID+')' AS TSA_PJNAME,TSA_ENGNAME,TSA_ENGSTRSMTYPE,TSA_TCCLERKNM from View_TM_TaskAssign where " + this.GetMyTast() + " and charindex('-',TSA_ID)=0 order by TSA_PJID,TSA_ID";
ExportTMDataFromDB.ExportTaskIDContainsOld(sql);
}
/// <summary>
/// 导出制作明细表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnMsAllExport_OnClick(object sender, EventArgs e)
{
ExportTMDataFromDB.ExportMSAllData(tsaid.Text);
}
/// <summary>
/// 导出Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExport_OnClick(object sender, EventArgs e)
{
string sqltext = "select TSA_ID,TSA_FY,TSA_STATUS,TSA_ENGTYPE,TSA_STFORCODE,PJ_NAME+'('+TSA_PJID+')' AS PJ_NAME,TSA_ENGNAME,ST_NAME,TSA_TOTALWGHT,TSA_RECVDATE,TSA_ADDTIME from View_TM_WorkAmount where " + ViewState["Basic"].ToString() + " and (TSA_SHIP IS NULL OR TSA_SHIP='') order by TSA_STFORCODE";
ExportTMDataFromDB.ExportTaskID(sqltext);
}
/// <summary>
/// 导出制作明细表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnMpExport_OnClick(object sender, EventArgs e)
{
ExportTMDataFromDB.ExportMPData(ddlLotNumList.SelectedValue, tsaid.Text, ddlmptype.SelectedValue);
this.ClientScript.RegisterStartupScript(GetType(), "js", "setTimeout('self.close()',2000);", true);
}
