/// <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); } }