/// <summary>
/// 执行存储过生成材料计划
/// </summary>
/// <param name="psv"></param>
protected DataTable ExecMpCreate(ParamsMpCreate pmc)
{
DataTable dt;
try
{
SqlConnection sqlConn = new SqlConnection();
SqlCommand sqlCmd = new SqlCommand();
sqlConn.ConnectionString = DBCallCommon.GetStringValue("connectionStrings");
DBCallCommon.PrepareStoredProc(sqlConn, sqlCmd, "[PRO_TM_OutCreate]");
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@Engid", pmc.Engid, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@Engtype", pmc.Engtype, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@MpChange", pmc.MpChange, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@Mpno", pmc.Mpno, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@MpType", pmc.MpType, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@Pjid", pmc.Pjid, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@StrWhere", pmc.StrWhere, SqlDbType.Text, 3000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@TableName", pmc.TableName, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@OrgTable", pmc.OrgTable, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@Userid", pmc.Userid, SqlDbType.Text, 1000);
sqlConn.Open();
sqlCmd.CommandTimeout = 1000;
////sqlCmd.ExecuteNonQuery();
dt = DBCallCommon.GetDataTableUsingCmd(sqlCmd);
sqlConn.Close();
}
catch (Exception)
{
throw;
}
return(dt);
}
protected void btnMpCreate_OnClick(object sender, EventArgs e)
{
if (GridView2.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('没有记录，无法生成！！！');window.close();", true);
return;
}
if (Session["Mp_Count"].ToString() == "0")
{
Session["Mp_Count"] = 1;
ParamsMpCreate pmc = new ParamsMpCreate();
pmc.MpChange = ViewState["mpchange"].ToString();
pmc.MpType = ViewState["mptype"].ToString();
pmc.TableName = ViewState["tablename"].ToString();
pmc.StrWhere = ViewState["strwhere"].ToString();
pmc.Pjid = ViewState["pjid"].ToString();
pmc.Mpno = ViewState["mpno"].ToString();
pmc.Engid = ViewState["engid"].ToString();
pmc.Engtype = ViewState["engtype"].ToString();
pmc.Userid = Session["UserID"].ToString();
pmc.OrgTable = ViewState["orgtable"].ToString();
DataTable dt = this.ExecMpCreate(pmc);
if (dt.Rows[0][0].ToString() == "OK")
{
Response.Redirect("TM_Out_Source.aspx?id=" + pmc.Mpno);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('程序出错，请与管理员联系！！！');window.close();", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请勿重复提交！！！');window.close();", true);
}
}
