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