protected void btLista_Click(object sender, EventArgs e)
{
ASPxPageControl1.TabPages[0].Enabled = false;
ASPxPageControl1.ActiveTabIndex = 1;
ASPxPageControl1.TabPages[1].Enabled = true;
ASPxPageControl1.DataBind();
}
protected void btCadastrar_Click(object sender, EventArgs e)
{
ApagaCampos();
Session["OperacaoCargo"] = 1;
ASPxPageControl1.TabPages[0].Enabled = true;
ASPxPageControl1.ActiveTabIndex = 0;
ASPxPageControl1.TabPages[1].Enabled = false;
ASPxPageControl1.DataBind();
}
protected void btAlterar_Click(object sender, EventArgs e)
{
PreencheCampos();
ASPxPageControl1.TabPages[0].Enabled = true;
ASPxPageControl1.TabPages[1].Enabled = false;
Session["OperacaoCargo"] = 2;
ASPxPageControl1.ActiveTabIndex = 0;
ASPxPageControl1.DataBind();
}
private void Load_MRP(string docnumber)
{
ASPxHiddenField hidStatusKey = Page.FindControl("StatusKey") as ASPxHiddenField;
string query = "SELECT tbl_MRP_List.*, " +
" vw_AXEntityTable.NAME AS EntityCodeDesc, " +
" vw_AXOperatingUnitTable.NAME AS BUCodeDesc, " +
" tbl_MRP_Status.StatusName, tbl_Users.Lastname, " +
" tbl_Users.Firstname, tbl_MRP_List.EntityCode, " +
" tbl_MRP_List.BUCode " +
" FROM tbl_MRP_List LEFT OUTER JOIN tbl_Users ON tbl_MRP_List.CreatorKey = tbl_Users.PK " +
" LEFT OUTER JOIN vw_AXOperatingUnitTable ON tbl_MRP_List.BUCode = vw_AXOperatingUnitTable.OMOPERATINGUNITNUMBER " +
" LEFT OUTER JOIN tbl_MRP_Status ON tbl_MRP_List.StatusKey = tbl_MRP_Status.PK " +
" LEFT OUTER JOIN vw_AXEntityTable ON tbl_MRP_List.EntityCode = vw_AXEntityTable.ID " +
" WHERE dbo.tbl_MRP_List.DocNumber = '" + docnumber + "' " +
" ORDER BY dbo.tbl_MRP_List.DocNumber DESC";
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
string firstname = "", lastname = "";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
mrp_key = Convert.ToInt32(reader["PK"].ToString());
entitycode = reader["EntityCode"].ToString();
DocNum.Text = reader["DocNumber"].ToString();
DateCreated.Text = reader["DateCreated"].ToString();
dateCreated = Convert.ToDateTime(reader["DateCreated"]);
EntityCode.Text = reader["EntityCodeDesc"].ToString();
BUCode.Text = reader["BUCodeDesc"].ToString();
Month.Text = MRPClass.Month_Name(Int32.Parse(reader["MRPMonth"].ToString()));
Year.Text = reader["MRPYear"].ToString();
Status.Text = reader["StatusName"].ToString();
iStatusKey = Convert.ToInt32(reader["StatusKey"]);
firstname = reader["Firstname"].ToString();
lastname = reader["Lastname"].ToString();
entitycode = reader["EntityCode"].ToString();
Entity.Text = reader["EntityCode"].ToString();
BU.Text = reader["BUCode"].ToString();
buCode = reader["BUCode"].ToString();
Creator.Text = EncryptionClass.Decrypt(firstname) + " " + EncryptionClass.Decrypt(lastname);
}
reader.Close();
iStatusKey = MRPClass.MRP_Line_Status(mrp_key, wrkflwln);
WorkFlowLineLbl.Text = wrkflwln.ToString();
WorkFlowLineTxt.Text = wrkflwln.ToString();
StatusKeyLbl.Text = iStatusKey.ToString();
StatusKeyTxt.Text = iStatusKey.ToString();
Creator.Text = EncryptionClass.Decrypt(firstname) + " " + EncryptionClass.Decrypt(lastname);
DirectMaterialsRoundPanel.HeaderText = "[" + DocNum.Text.ToString().Trim() + "] Direct Materials";
OpexRoundPanel.HeaderText = "[" + DocNum.Text.ToString().Trim() + "] Operational Expense";
ManpowerRoundPanel.HeaderText = "[" + DocNum.Text.ToString().Trim() + "] Man Power";
CapexRoundPanel.HeaderText = "[" + DocNum.Text.ToString().Trim() + "] Capital Expenditure";
//ASPxPageControl pageControl = grid.FindEditFormTemplateControl("RevenuePageControl") as ASPxPageControl;
ASPxHiddenField hfwrkLine = ASPxPageControl1.FindControl("ASPxHiddenFieldDMWrkFlwLnInventAnal") as ASPxHiddenField;
ASPxHiddenField hfstatKey = ASPxPageControl1.FindControl("ASPxHiddenFieldDMStatusKeyInventAnal") as ASPxHiddenField;
hfwrkLine["hidden_value"] = wrkflwln.ToString();
hfstatKey["hidden_value"] = iStatusKey.ToString();
}
