public static PMPAudit ExecuteReturnAuditQuery(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(connectionString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();
PMPAudit au = new PMPAudit();
au.PMP_MFDepSignSuggestion1 = commandParameters[1].Value.ToString();
au.PMP_MFDepSignMan1 = commandParameters[2].Value.ToString();
au.PMP_MFDepSignTime1 = commandParameters[3].Value.ToString();
au.PMP_MFDepSignResult1 = commandParameters[4].Value.ToString();
au.PMP_MBossSignSuggestion1 = commandParameters[5].Value.ToString();
au.PMP_MBossSignMan1 = commandParameters[6].Value.ToString();
au.PMP_MBossSignTime1 = commandParameters[7].Value.ToString();
au.PMP_MBossSignResult1 = commandParameters[8].Value.ToString();
au.PMP_MPDepSignSuggestion1 = commandParameters[9].Value.ToString();
au.PMP_MPDepSignMan1 = commandParameters[10].Value.ToString();
au.PMP_MPDepSignTime1 = commandParameters[11].Value.ToString();
au.PMP_MPDepSignResult1 = commandParameters[12].Value.ToString();
return(au);
}
}
public PMPAudit getAudit()
{
PMPAudit au = new PMPAudit();
au.PMP_MBossSignMan1 = PMP_MBossSignMan1;
au.PMP_MBossSignResult1 = PMP_MBossSignResult1;
au.PMP_MBossSignSuggestion1 = PMP_MBossSignSuggestion1;
au.PMP_MBossSignTime1 = PMP_MBossSignTime1;
au.PMP_MFDepSignMan1 = PMP_MFDepSignMan1;
au.PMP_MFDepSignResult1 = PMP_MFDepSignResult1;
au.PMP_MFDepSignSuggestion1 = PMP_MFDepSignSuggestion1;
au.PMP_MFDepSignTime1 = PMP_MFDepSignTime1;
au.PMP_MPDepSignMan1 = PMP_MPDepSignMan1;
au.PMP_MPDepSignResult1 = PMP_MPDepSignResult1;
au.PMP_MPDepSignSuggestion1 = PMP_MPDepSignSuggestion1;
au.PMP_MPDepSignTime1 = PMP_MPDepSignTime1;
return(au);
}
public PMPAudit Query_Audit(Guid id)
{
SqlParameter[] para =
{
new SqlParameter("@PMP_ID", SqlDbType.UniqueIdentifier),
new SqlParameter("@PMP_MFDepSignSuggestion", SqlDbType.VarChar, 400),
new SqlParameter("@PMP_MFDepSignMan", SqlDbType.VarChar, 20),
new SqlParameter("@PMP_MFDepSignTime", SqlDbType.DateTime),
new SqlParameter("@PMP_MFDepSignResult", SqlDbType.VarChar, 20),
new SqlParameter("@PMP_MBossSignSuggestion", SqlDbType.VarChar, 400),
new SqlParameter("@PMP_MBossSignMan", SqlDbType.VarChar, 20),
new SqlParameter("@PMP_MBossSignTime", SqlDbType.DateTime),
new SqlParameter("@PMP_MBossSignResult", SqlDbType.VarChar, 20),
new SqlParameter("@PMP_MPDepSignSuggestion", SqlDbType.VarChar, 400),
new SqlParameter("@PMP_MPDepSignMan", SqlDbType.VarChar, 20),
new SqlParameter("@PMP_MPDepSignTime", SqlDbType.DateTime),
new SqlParameter("@PMP_MPDepSignResult", SqlDbType.VarChar, 20)
};
para[0].Value = id;
para[1].Direction = ParameterDirection.Output;
para[2].Direction = ParameterDirection.Output;
para[3].Direction = ParameterDirection.Output;
para[4].Direction = ParameterDirection.Output;
para[5].Direction = ParameterDirection.Output;
para[6].Direction = ParameterDirection.Output;
para[7].Direction = ParameterDirection.Output;
para[8].Direction = ParameterDirection.Output;
para[9].Direction = ParameterDirection.Output;
para[10].Direction = ParameterDirection.Output;
para[11].Direction = ParameterDirection.Output;
para[12].Direction = ParameterDirection.Output;
PMPAudit au = SqlHelper.ExecuteReturnAuditQuery(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_S_PMPAudit", para);
return(au);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Details")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
if (row.Cells[9].Text == "已建立")
{
GridView1.SelectedIndex = row.RowIndex;
Button4.Visible = false;
Panel3.Visible = true;
Guid pmpid = new Guid(e.CommandArgument.ToString());
Label14.Text = pmpid.ToString();
GridView2.DataSource = mp.Query_MPlanDetail(pmpid);
//GridView1.DataSource = mp.Query_MPlan(syear, smonth, state,Convert.ToInt32(Linenum.Text));
GridView2.DataBind();
Label10.Text = "查看";
Label11.Text = row.Cells[2].Text;
Label12.Text = row.Cells[3].Text;
Panel4.Visible = false;
Panel5.Visible = false;
Panel6.Visible = false;
Panel7.Visible = false;
Panel31.Visible = false;
GridView2.Columns[12].Visible = false;
GridView2.SelectedIndex = -1;
}
else
{
GridView1.SelectedIndex = row.RowIndex;
Button4.Visible = false;
Panel3.Visible = true;
Guid pmpid = new Guid(e.CommandArgument.ToString());
Label14.Text = pmpid.ToString();
GridView2.DataSource = mp.Query_MPlanDetailFlash(pmpid);
//GridView1.DataSource = mp.Query_MPlan(syear, smonth, state,Convert.ToInt32(Linenum.Text));
GridView2.DataBind();
Label10.Text = "查看";
Label11.Text = row.Cells[2].Text;
Label12.Text = row.Cells[3].Text;
Panel4.Visible = false;
Panel5.Visible = false;
Panel6.Visible = false;
Panel7.Visible = false;
Panel31.Visible = false;
GridView2.Columns[12].Visible = false;
GridView2.SelectedIndex = -1;
}
}
if (e.CommandName == "Make")
{
Panel31.Visible = true;
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
GridView1.SelectedIndex = row.RowIndex;
if (row.Cells[9].Text == "未建立")
{
Label10.Text = "制定";
Label11.Text = row.Cells[2].Text;
Label12.Text = row.Cells[3].Text;
Panel3.Visible = true;
Salesid = new Guid(e.CommandArgument.ToString());
Label13.Text = Salesid.ToString();
Button4.Visible = true;
TextBox6.Text = "";
TextBox7.Text = "";
string add;
if (Label10.Text == "制定")
{
add = "否";
}
else
{
add = "是";
}
Panel4.Visible = false;
Panel5.Visible = false;
Panel6.Visible = false;
Panel7.Visible = false;
int year = int.Parse(Label11.Text);
int month = int.Parse(Label12.Text);
string man = Session["UserName"].ToString();
string makedate = DateTime.Now.ToString("yyyy-MM-dd");
GridView2.Columns[11].Visible = true;
GridView2.Columns[10].Visible = true;
Guid sid = new Guid(Label13.Text);
Guid pmpid = mp.Insert_PMP(sid, year, month, man, makedate, null, null, add, Convert.ToInt32(Linenum.Text));
Label14.Text = pmpid.ToString();
mp.UpdatePlanState(pmpid);
GridView2.DataSource = mp.Query_MPlanDetail(new Guid(Label14.Text));
GridView2.DataBind();
GridView1.DataSource = mp.Query_MPlan(syear, smonth, state, Convert.ToInt32(Linenum.Text));
GridView1.DataBind();
GridView2.SelectedIndex = -1;
}
else
{
GridView2.Columns[11].Visible = true;
GridView2.Columns[12].Visible = true;
Button4.Visible = false;
Panel3.Visible = true;
Guid pmpid = new Guid(row.Cells[1].Text);
Label14.Text = pmpid.ToString();
GridView2.DataSource = mp.Query_MPlanDetail(pmpid);
GridView2.DataBind();
Label10.Text = "查看";
Label11.Text = row.Cells[2].Text;
Label12.Text = row.Cells[3].Text;
Panel4.Visible = false;
Panel5.Visible = false;
Panel6.Visible = false;
Panel7.Visible = false;
Panel31.Visible = false;
Button4.Visible = true;
Panel31.Visible = true;
GridView2.SelectedIndex = -1;
}
}
if (e.CommandName == "Audit")
{
GridView2.Columns[8].Visible = false;
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
GridView1.SelectedIndex = row.RowIndex;
Panel3.Visible = true;
MMPid = new Guid(e.CommandArgument.ToString());
GridView2.DataSource = mp.Query_MPlanDetail(MMPid);
GridView2.DataBind();
GridView1.DataSource = mp.Query_MPlan(syear, smonth, state, Convert.ToInt32(Linenum.Text));
Panel3.Visible = false;
Panel32.Visible = false;
Panel4.Visible = false;
Panel5.Enabled = false;
Panel6.Enabled = false;
Panel7.Enabled = false;
Button4.Visible = false;
if (Session["UserRole"].ToString().Contains("材料月计划审核生产部"))
{
Panel5.Enabled = true;
}
if (Session["UserRole"].ToString().Contains("材料月计划审核财务部"))
{
Panel6.Enabled = true;
}
if (Session["UserRole"].ToString().Contains("材料月计划审核副总"))
{
Panel7.Enabled = true;
}
Panel5.Visible = true;
Panel6.Visible = true;
Panel7.Visible = true;
Label11.Text = row.Cells[2].Text;
Label12.Text = row.Cells[3].Text;
PMPAudit au = new PMPAudit();
au = mp.Query_Audit(MMPid);
Label1.Text = au.PMP_MPDepSignMan1.ToString();
Label2.Text = au.PMP_MPDepSignTime1.ToString();
if (Label2.Text != "")
{
Label2.Text = Convert.ToDateTime(Label2.Text).ToString("yyyy-MM-dd HH:mm");
}
TextBox3.Text = au.PMP_MPDepSignSuggestion1.ToString();
Label3.Text = au.PMP_MPDepSignResult1.ToString();
Label4.Text = au.PMP_MFDepSignMan1.ToString();
Label5.Text = au.PMP_MFDepSignTime1.ToString();
if (Label5.Text != "")
{
Label5.Text = Convert.ToDateTime(Label5.Text).ToString("yyyy-MM-dd HH:mm");
}
Label6.Text = au.PMP_MFDepSignResult1.ToString();
TextBox4.Text = au.PMP_MFDepSignSuggestion1.ToString();
Label7.Text = au.PMP_MBossSignMan1.ToString();
Label8.Text = au.PMP_MBossSignTime1.ToString();
if (Label8.Text != "")
{
Label8.Text = Convert.ToDateTime(Label8.Text).ToString("yyyy-MM-dd HH:mm");
}
Label9.Text = au.PMP_MBossSignResult1.ToString();
TextBox5.Text = au.PMP_MBossSignSuggestion1.ToString();
if (Label3.Text == "")
{
Label3.Text = "尚未会签";
P1.Visible = true;
TextBox3.Enabled = true;
}
else
{
TextBox3.Enabled = false;
P1.Visible = false;
}
if (Label3.Text == "审核驳回")
{
Label3.ForeColor = Color.FromName("#f64a80");
}
if (Label3.Text == "审核通过")
{
Label3.ForeColor = Color.FromName("#34b2e1");
}
if (Label6.Text == "")
{
Label6.Text = "尚未会签";
P2.Visible = true;
TextBox4.Enabled = true;
}
else
{
TextBox4.Enabled = false;
P2.Visible = false;
}
if (Label6.Text == "审核驳回")
{
Label6.ForeColor = Color.FromName("#f64a80");
}
if (Label6.Text == "审核通过")
{
Label6.ForeColor = Color.FromName("#34b2e1");
}
if (Label9.Text == "")
{
Label9.Text = "尚未会签";
P3.Visible = true;
TextBox5.Enabled = true;
}
else
{
TextBox5.Enabled = false;
P3.Visible = false;
}
if (Label9.Text == "审核驳回")
{
Label9.ForeColor = Color.FromName("#f64a80");
}
if (Label9.Text == "审核通过")
{
Label9.ForeColor = Color.FromName("#34b2e1");
}
}
if (e.CommandName == "Bonus")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
int check = mp.CheckAddAvailable(int.Parse(row.Cells[2].Text), int.Parse(row.Cells[3].Text));
if (check < 1)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('现在不需要新增材料月计划,所有生产计划都已分配材料！')", true);
}
else
{
Panel4.Visible = false;
Panel5.Visible = false;
Panel6.Visible = false;
Panel7.Visible = false;
GridView2.SelectedIndex = -1;
Panel31.Visible = true;
GridView1.SelectedIndex = -1;
Label10.Text = "新增";
Label11.Text = row.Cells[2].Text;
Label12.Text = row.Cells[3].Text;
Panel3.Visible = true;
Salesid = new Guid(e.CommandArgument.ToString());
GridView1.DataSource = mp.Query_MPlan(syear, smonth, state, Convert.ToInt32(Linenum.Text));
GridView2.Columns[7].Visible = true;
GridView2.Columns[8].Visible = true;
Label13.Text = Salesid.ToString();
Button4.Visible = true;
TextBox6.Text = "";
TextBox7.Text = "";
string add = "是";
Panel4.Visible = false;
Panel5.Visible = false;
Panel6.Visible = false;
Panel7.Visible = false;
int year = int.Parse(Label11.Text);
int month = int.Parse(Label12.Text);
string man = Session["UserName"].ToString();
string makedate = DateTime.Now.ToString("yyyy-MM-dd");
Guid sid = new Guid(Label13.Text);
Guid pmpid = mp.Insert_PMP_add(sid, year, month, man, makedate, null, null, add, Convert.ToInt32(Linenum.Text));
Label14.Text = pmpid.ToString();
GridView2.DataSource = mp.Query_MPlanDetail(new Guid(Label14.Text));
GridView2.DataBind();
GridView1.DataSource = mp.Query_MPlan(syear, smonth, state, Convert.ToInt32(Linenum.Text));
GridView1.DataBind();
GridView2.SelectedIndex = -1;
mp.UpdatePlanState_New(pmpid);
}
}
}
