public List <CatName> getCatName() { TeraManager tmm = new TeraManager(); DataTable dt = new DataTable(); List <CatName> lst_catname = new List <CatName>(); try { string strQuery = string.Empty; strQuery = " select cat_inx ,cat_name ,cat_color "; strQuery += " from DATALAB_OPER.PSS_CALENDAR_CATEGORIES order by cat_inx "; dt = tmm.GetDataTableTera(strQuery); CatName obj_catname; for (int i = 0; i < dt.Rows.Count; i++) { obj_catname = new CatName(); obj_catname.Cat_inx = Convert.ToInt16(dt.Rows[i]["cat_inx"].ToString()); obj_catname.Cat_name = dt.Rows[i]["cat_name"].ToString(); obj_catname.Cat_color = dt.Rows[i]["cat_color"].ToString(); lst_catname.Add(obj_catname); } } catch (Exception e) { Console.Out.WriteLine(e.Message.ToString()); } return(lst_catname); }
/// <summary> /// Gets the hash code /// </summary> /// <returns>Hash code</returns> public override int GetHashCode() { unchecked // Overflow is fine, just wrap { var hashCode = 41; // Suitable nullity checks etc, of course :) if (CatName != null) { hashCode = hashCode * 59 + CatName.GetHashCode(); } if (CatRoletype != null) { hashCode = hashCode * 59 + CatRoletype.GetHashCode(); } if (CatGtmEntryodataBind != null) { hashCode = hashCode * 59 + CatGtmEntryodataBind.GetHashCode(); } if (CatTeamMemberodataBind != null) { hashCode = hashCode * 59 + CatTeamMemberodataBind.GetHashCode(); } return(hashCode); } }
private void button3_Click(object sender, EventArgs e) { OleDbConnection Connection = new OleDbConnection(Con.ConnectionString()); OleDbCommand DEL = new OleDbCommand("DELETE FROM Catagory WHERE CatName=@CatName", Connection); DEL.Parameters.AddWithValue("@CatName", CatName.Text.ToString()); try { Connection.Open(); int a = DEL.ExecuteNonQuery(); Connection.Close(); if (a == 1) { toolStripStatusLabel1.Text = "Successfully Deleted"; CatName.Text = ""; Des.Text = ""; Sup1.Text = ""; Sup2.Text = ""; Sup3.Text = ""; CatName.Focus(); } else { toolStripStatusLabel1.Text = "Error Catagory Not Deleted"; } } catch { } }
/// <summary> /// Returns true if Body3 instances are equal /// </summary> /// <param name="other">Instance of Body3 to be compared</param> /// <returns>Boolean</returns> public bool Equals(Body3 other) { if (ReferenceEquals(null, other)) { return(false); } if (ReferenceEquals(this, other)) { return(true); } return (( CatName == other.CatName || CatName != null && CatName.Equals(other.CatName) ) && ( CatRoletype == other.CatRoletype || CatRoletype != null && CatRoletype.Equals(other.CatRoletype) ) && ( CatGtmEntryodataBind == other.CatGtmEntryodataBind || CatGtmEntryodataBind != null && CatGtmEntryodataBind.Equals(other.CatGtmEntryodataBind) ) && ( CatTeamMemberodataBind == other.CatTeamMemberodataBind || CatTeamMemberodataBind != null && CatTeamMemberodataBind.Equals(other.CatTeamMemberodataBind) )); }
private void button2_Click(object sender, EventArgs e) { CatName.Text = ""; Des.Text = ""; Sup1.SelectedIndex = -1; Sup2.SelectedIndex = -1; Sup3.SelectedIndex = -1; toolStripStatusLabel1.Text = "Cleared"; CatName.Focus(); }
private void MyInitForUpdate() { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from Cats order by Orders desc"; conn.Open(); SqlDataReader rd1 = cmd.ExecuteReader(); CatName.DataSource = rd1; CatName.DataValueField = "ID"; CatName.DataTextField = "CatName"; CatName.DataBind(); rd1.Close(); string sql = "select * from Subs order by valid desc,Orders desc;select * from Subs where ID = @ID"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@ID", Convert.ToInt16(Request["ID"])); SqlDataReader rd = cmd.ExecuteReader(); // string CatID = rd["CatID"].ToString(); rd.NextResult(); if (rd.Read()) { SubName.Text = rd["SubName"].ToString(); Description.Text = rd["Description"].ToString(); string CatID = rd["CatID"].ToString(); if (CatName.Items.FindByValue(CatID) != null) { CatName.ClearSelection(); CatName.Items.FindByValue(CatID).Selected = true; } } //读取单选框所选择的信息 int valid = Convert.ToInt32(rd["Valid"]); if (valid == 1) { true1.Checked = true; } else { false1.Checked = true; } rd.Close(); conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { CatName.Focus(); if (!String.IsNullOrEmpty(Request["ID"])) { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); string sql = "select * from cats order by valid desc,Orders desc;select * from Cats where ID = @ID"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@ID", Convert.ToInt16(Request["ID"])); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); rd.NextResult(); if (rd.Read()) { CatName.Text = rd["CatName"].ToString(); Description.Text = rd["Description"].ToString(); Description.Text = rd["Description"].ToString(); int i = Convert.ToInt16(rd["Valid"]); } rd.Close(); conn.Close(); } } else { MyDataBind(); } } }
private void NewButton_Click(object sender, RoutedEventArgs e) { ViewModel.ResetSelected(); CatName.Focus(); }
private List <String> BuildLevelList() { Levels = new List <string>(); string category = CatName.ToUpper(); //No Menu Storage if (category.Contains("NO MS") || category.Contains("NMS") || category.Contains("NO MENU STORAGE")) { CatDetect = "Any% No Menu Storage"; if (SoleRegret) { Levels.Add("Sole Regret"); } Levels.Add("Wharf District"); Levels.Add("Workmen Ward"); Levels.Add("Hanging Gardens"); Levels.Add("Cinderbrick Fort"); Levels.Add("Roathus Lagoon"); Levels.Add("Colford Cauldron"); Levels.Add("Burstone Quarry"); Levels.Add("End"); } //All Story Levels else if (category.Contains("ASL") || category.Contains("ALL STORY LEVELS")) { CatDetect = "All Story Levels"; if (SoleRegret) { Levels.Add("Sole Regret"); } Levels.Add("Wharf District"); Levels.Add("Workmen Ward"); Levels.Add("Melting Pot"); Levels.Add("Sundown Path"); Levels.Add("Hanging Gardens"); Levels.Add("Cinderbrick Fort"); Levels.Add("Pyth Orchard"); Levels.Add("Langston River"); Levels.Add("Prosper Bluff"); Levels.Add("Wild Outskirts"); Levels.Add("Jawson Bog"); Levels.Add("Roathus Lagoon"); Levels.Add("Point Lemaign"); Levels.Add("Colford Cauldron"); Levels.Add("Mount Zand"); Levels.Add("Burstone Quarry"); Levels.Add("Urzendra Gate"); Levels.Add("Zulten's Hollow"); if (Tazal) { Levels.Add("Tazal Terminals 1"); Levels.Add("Tazal Terminals 2"); } else if (Ram) { Levels.Add("Battering Ram"); Levels.Add("Tazal Terminals 2"); } else { Levels.Add("Tazal Terminals"); } Levels.Add("End"); } //All Weapons else if (category.Contains("WEAPONS") || category.Contains("AW")) { CatDetect = "All Weapons"; if (SoleRegret) { Levels.Add("Sole Regret"); } Levels.Add("Wharf District"); Levels.Add("Workmen Ward"); Levels.Add("Hanging Gardens"); Levels.Add("Cinderbrick Fort"); Levels.Add("Roathus Lagoon"); Levels.Add("Prosper Bluff"); Levels.Add("Wild Outskirts"); Levels.Add("Point Lemaign"); Levels.Add("Mount Zand"); Levels.Add("Urzendra Gate"); Levels.Add("Zulten's Hollow"); Levels.Add("Colford Cauldron"); Levels.Add("End"); } //Any% else if (category.Contains("ANY%")) { CatDetect = "Any%"; if (SoleRegret) { Levels.Add("Sole Regret"); } Levels.Add("Wharf District"); Levels.Add("End"); } //All Interactive Collectibles else if (category.Contains("COLLECTIBLES") || category.Contains("AIC")) { CatDetect = "All Interactive Collectibles"; if (SoleRegret) { Levels.Add("Sole Regret"); } Levels.Add("Wharf District"); Levels.Add("Melting Pot"); Levels.Add("Workmen Ward"); Levels.Add("Sundown Path"); Levels.Add("Cinderbrick Fort"); Levels.Add("Pyth Orchard"); Levels.Add("Scrap Yard"); Levels.Add("Zulwood Grove"); Levels.Add("Windbag Ranch"); Levels.Add("Breaker Barracks"); Levels.Add("Trapper Shingle"); Levels.Add("Hanging Gardens"); Levels.Add("Roathus Lagoon"); Levels.Add("Prosper Bluff"); Levels.Add("Wild Outskirts"); Levels.Add("Point Lemaign"); Levels.Add("Colford Cauldron"); Levels.Add("Mount Zand"); Levels.Add("Urzendra Gate"); Levels.Add("Zulten's Hollow"); Levels.Add("Trigger Hill"); Levels.Add("Boundless Bay"); Levels.Add("Slinger Range"); Levels.Add("Camp Dauncy"); Levels.Add("Grady Incinerator"); Levels.Add("Mancer Observatory"); Levels.Add("Burstone Quarry"); Levels.Add("End"); } //Dreams and Challenges else if (category.Contains("DREAMS") || category.Contains("DC")) { CatDetect = "Dreams and Challenges"; if (SoleRegret) { Levels.Add("Sole Regret"); } Levels.Add("Wharf District"); Levels.Add("Cinderbrick Fort"); Levels.Add("Workmen Ward"); Levels.Add("Hanging Gardens"); Levels.Add("Colford Cauldron"); Levels.Add("Mount Zand"); Levels.Add("Urzendra Gate"); Levels.Add("Zulten's Hollow"); Levels.Add("Trigger Hill"); Levels.Add("Boundless Bay"); Levels.Add("Scrap Yard"); Levels.Add("Zulwood Grove"); Levels.Add("Windbag Ranch"); Levels.Add("Breaker Barracks"); Levels.Add("Trapper Shingle"); Levels.Add("Bullhead Court"); Levels.Add("Camp Dauncy"); Levels.Add("Slinger Range"); Levels.Add("Grady Incinerator"); Levels.Add("Mancer Observatory"); Levels.Add("Point Lemaign"); Levels.Add("Kid's Dream"); Levels.Add("Singer's Dream"); Levels.Add("Survivor's Dream"); Levels.Add("End"); } //Fail Case else { CatDetect = "Error"; return(null); } if (Levels.Count != File.GetElementsByTagName("Name").Count) { return(null); } return(Levels); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["RoleID"] == null || Session["UserID"] == null) { Util.ShowMessage("用户登录超时,请重新登录!", "Login2.aspx"); } else { int RoleID = Convert.ToInt16(Session["RoleID"].ToString()); if (RoleID > 1) { Util.ShowMessage("对不起,你无权访问该页面!", "User_Center.aspx"); } else { LabelUserID.Text = Request.QueryString["ID"]; CatName.Focus(); if (!String.IsNullOrEmpty(Request["ID"])) { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); string sql = "select * from cats order by valid desc,Orders desc;select * from Cats where ID = @ID"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@ID", Convert.ToInt16(Request["ID"])); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); rd.NextResult(); if (rd.Read()) { CatName.Text = rd["CatName"].ToString(); Description.Text = rd["Description"].ToString(); //读取单选框所选择的信息 int valid = Convert.ToInt32(rd["Valid"]); if (valid == 1) { true1.Checked = true; } else { false1.Checked = true; } int IsShow = Convert.ToInt32(rd["IsShow"]); if (IsShow == 1) { true2.Checked = true; } else { false2.Checked = true; } } rd.Close(); conn.Close(); } } else { MyDataBind(); } //using (sqlconnection conn = new db().getconnection()) //{ // string sql = "select * from Cats order by ID desc"; // SqlCommand cmd = new SqlCommand(sql, conn); // conn.Open(); // SqlDataReader rd = cmd.ExecuteReader(); // cmd.Parameters.AddWithValue("@ID", Label1.Text); // rd = cmd.ExecuteReader(); // if (rd.Read()) // { // int valid = Convert.ToInt32(rd["Valid"]); // if (valid == 1) // { // true1.Checked = true; // } // else // { // false1.Checked = true; // } } } } }
private void button1_Click(object sender, EventArgs e) { OleDbConnection Connection = new OleDbConnection(Con.ConnectionString()); if (CatName.Text.ToString().Trim(' ') == "") { toolStripStatusLabel1.Text = "Please Enter Catagory Name"; CatName.Text = ""; CatName.Focus(); } else if ((Sup1.SelectedIndex == -1) && (Sup2.SelectedIndex == -1) && (Sup3.SelectedIndex == -1)) { toolStripStatusLabel1.Text = "Please Select atleast One Supplier for this Catagory"; Sup1.Focus(); } else { try { if (button1.Text.ToString() == "Save") { OleDbCommand INSERT = new OleDbCommand("INSERT INTO Catagory(CatName,Descriptions,Supplier1,Supplier2,Supplier3) VALUES(@CatName,@Descriptions,@Supplier1,@Supplier2,@Supplier3)", Connection); INSERT.Parameters.AddWithValue("@CatName", CatName.Text.ToString()); INSERT.Parameters.AddWithValue("@Descriptions", Des.Text.ToString()); if (Sup1.SelectedIndex != -1) { INSERT.Parameters.AddWithValue("@Supplier1", Sup1.SelectedItem.ToString()); } else { INSERT.Parameters.AddWithValue("@Supplier1", ""); } if (Sup2.SelectedIndex != -1) { INSERT.Parameters.AddWithValue("@Supplier2", Sup2.SelectedItem.ToString()); } else { INSERT.Parameters.AddWithValue("@Supplier2", ""); } if (Sup3.SelectedIndex != -1) { INSERT.Parameters.AddWithValue("@Supplier3", Sup3.SelectedItem.ToString()); } else { INSERT.Parameters.AddWithValue("@Supplier3", ""); } Connection.Open(); int a = INSERT.ExecuteNonQuery(); Connection.Close(); if (a == 1) { toolStripStatusLabel1.Text = "Successfully Saved"; CatName.Text = ""; Des.Text = ""; Sup1.Text = ""; Sup2.Text = ""; Sup3.Text = ""; CatName.Focus(); } else { toolStripStatusLabel1.Text = "Error Catagory not Saved"; } } else { OleDbCommand UPDES = new OleDbCommand("UPDATE Catagory SET Descriptions=@Descriptions WHERE CatName=@CatName", Connection); UPDES.Parameters.AddWithValue("@CatName", CatName.Text.ToString()); UPDES.Parameters.AddWithValue("@Descriptions", Des.Text.ToString()); OleDbCommand UPSUP1 = new OleDbCommand("UPDATE Catagory SET Supplier1=@Supplier1 WHERE CatName=@CatName", Connection); if (Sup1.SelectedIndex != -1) { UPSUP1.Parameters.AddWithValue("@Supplier1", Sup1.SelectedItem.ToString()); } else { UPSUP1.Parameters.AddWithValue("@Supplier1", ""); } UPSUP1.Parameters.AddWithValue("@CatName", CatName.Text.ToString()); OleDbCommand UPSUP2 = new OleDbCommand("UPDATE Catagory SET Supplier2=@Supplier2 WHERE CatName=@CatName", Connection); if (Sup2.SelectedIndex != -1) { UPSUP2.Parameters.AddWithValue("@Supplier2", Sup2.SelectedItem.ToString()); } else { UPSUP2.Parameters.AddWithValue("@Supplier2", ""); } UPSUP2.Parameters.AddWithValue("@CatName", CatName.Text.ToString()); OleDbCommand UPSUP3 = new OleDbCommand("UPDATE Catagory SET Supplier3=@Supplier3 WHERE CatName=@CatName", Connection); if (Sup3.SelectedIndex != -1) { UPSUP3.Parameters.AddWithValue("@Supplier3", Sup3.SelectedItem.ToString()); } else { UPSUP3.Parameters.AddWithValue("@Supplier3", ""); } UPSUP3.Parameters.AddWithValue("@CatName", CatName.Text.ToString()); int a, b, c, d; Connection.Open(); a = UPDES.ExecuteNonQuery(); b = UPSUP1.ExecuteNonQuery(); c = UPSUP2.ExecuteNonQuery(); d = UPSUP3.ExecuteNonQuery(); Connection.Close(); if ((a == 1) && (b == 1) && (c == 1) && (d == 1)) { toolStripStatusLabel1.Text = "Successfully Updated"; CatName.Text = ""; Des.Text = ""; Sup1.Text = ""; Sup2.Text = ""; Sup3.Text = ""; CatName.Focus(); } else { toolStripStatusLabel1.Text = "Error Catagory Not Updated"; } } } catch { } } }