protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { genratetable(); date(); bind(); se = Convert.ToInt32(id); // Tree(Convert.ToString(Session["id"])); check(id); // ActiveidL = ActiveidL - 1; if (Activeid < ActiveidL) { aco = Activeid.ToString(); } else { aco = ActiveidL.ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { Label17.Visible = false; Label18.Visible = false; Label19.Visible = false; Label20.Visible = false; Label21.Visible = false; Label22.Visible = false; string[] Month = new string[12]; Month[0] = "Jan"; Month[1] = "Feb"; Month[2] = "Mar"; Month[3] = "Apr"; Month[4] = "May"; Month[5] = "Jun"; Month[6] = "Jul"; Month[7] = "Aug"; Month[8] = "Sep"; Month[9] = "Oct"; Month[10] = "Nov"; Month[11] = "Dec"; if (Page.IsPostBack == false) { DateTime last2 = System.DateTime.Now.AddMonths(-2); DateTime last = System.DateTime.Now.AddMonths(-1); int l = last.Month - 1; int l2 = last2.Month - 1; lnklast2.CommandArgument = l2.ToString(); lnklast.CommandArgument = l.ToString(); lnklast.Text = Month[l].ToString(); lnklast2.Text = Month[l2].ToString(); date(); se = Convert.ToInt32(Session["id"]); Tree(Convert.ToString(Session["id"])); check(Convert.ToString(Session["id"])); pNodeL(Convert.ToString(Session["id"]), "Left"); pNodeR(Convert.ToString(Session["id"]), "Right"); // ActiveidL = ActiveidL - 1; if (Activeid < ActiveidL) { aco = Activeid.ToString(); } else { aco = ActiveidL.ToString(); } } }
public override string ToString() { this.Init__jsonIgnore(); string json = string.Concat( __jsonIgnore.ContainsKey("Id") ? string.Empty : string.Format(", Id : {0}", Id == null ? "null" : Id.ToString()), __jsonIgnore.ContainsKey("Activeid") ? string.Empty : string.Format(", Activeid : {0}", Activeid == null ? "null" : string.Format("'{0}'", Activeid.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))), __jsonIgnore.ContainsKey("Gate") ? string.Empty : string.Format(", Gate : {0}", Gate == null ? "null" : string.Format("'{0}'", Gate.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))), __jsonIgnore.ContainsKey("Rewarditem") ? string.Empty : string.Format(", Rewarditem : {0}", Rewarditem == null ? "null" : Rewarditem.ToString()), __jsonIgnore.ContainsKey("State") ? string.Empty : string.Format(", State : {0}", State == null ? "null" : State.ToString()), __jsonIgnore.ContainsKey("Tel") ? string.Empty : string.Format(", Tel : {0}", Tel == null ? "null" : string.Format("'{0}'", Tel.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))), __jsonIgnore.ContainsKey("Time") ? string.Empty : string.Format(", Time : {0}", Time == null ? "null" : Time.Value.Subtract(new DateTime(1970, 1, 1)).TotalMilliseconds.ToString()), " }"); return(string.Concat("{", json.Substring(1))); }
protected void Page_Load(object sender, EventArgs e) { date(); se = Convert.ToInt32(Session["id"]); // Tree(Convert.ToString(Session["id"])); check(Convert.ToString(Session["id"])); pNodeL(Convert.ToString(Session["id"]), "Left"); pNodeR(Convert.ToString(Session["id"]), "Right"); // ActiveidL = ActiveidL - 1; if (Activeid < ActiveidL) { aco = Activeid.ToString(); } else { aco = ActiveidL.ToString(); } SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString; con.Open(); Int64 lbus = 0; { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select id from member_creation where upleg=@ID and side='Left'"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["ID"]); cmd.Connection = con; if (Convert.ToString(cmd.ExecuteScalar()) != "") { SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select active from cnt_down(@ID)"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(cmd.ExecuteScalar()); cmd1.Connection = con; Label33.Text = Convert.ToString(cmd1.ExecuteScalar()); lbus = Convert.ToInt64(cmd1.ExecuteScalar()); } else { Label33.Text = "0"; } } Int64 rbus = 0; { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select id from member_creation where upleg=@ID and side='Right'"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["ID"]); cmd.Connection = con; if (Convert.ToString(cmd.ExecuteScalar()) != "") { SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select active from cnt_down(@ID)"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(cmd.ExecuteScalar()); cmd1.Connection = con; Label34.Text = Convert.ToString(cmd1.ExecuteScalar()); rbus = Convert.ToInt64(cmd1.ExecuteScalar()); } else { Label34.Text = "0"; } } { SqlCommand cmd11 = new SqlCommand(); cmd11.CommandText = "select count(*) from member_creation where spon=@ID"; cmd11.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["ID"]); cmd11.Connection = con; if (Convert.ToInt64(cmd11.ExecuteScalar()) >= 4) { Label9.Text = "Yes"; } { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from rewards where reward=1 and id=@ID"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd.Connection = con; if (Convert.ToInt64(cmd.ExecuteScalar()) >= 1) { Label10.Text = "Yes"; SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select convert(varchar,date_entry,106) from rewards where reward=1 and id=@ID"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd1.Connection = con; Label3.Text = Convert.ToString(cmd1.ExecuteScalar()); } } } { if (lbus >= 30 && rbus >= 30) { Label11.Text = "Yes"; } { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from rewards where reward=2 and id=@ID"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd.Connection = con; if (Convert.ToInt64(cmd.ExecuteScalar()) >= 1) { Label12.Text = "Yes"; SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select convert(varchar,date_entry,106) from rewards where reward=2 and id=@ID"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd1.Connection = con; Label4.Text = Convert.ToString(cmd1.ExecuteScalar()); } } } { if (lbus >= 125 && rbus >= 125) { Label13.Text = "Yes"; } { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from rewards where reward=3 and id=@ID"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd.Connection = con; if (Convert.ToInt64(cmd.ExecuteScalar()) >= 1) { Label14.Text = "Yes"; SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select convert(varchar,date_entry,106) from rewards where reward=3 and id=@ID"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd1.Connection = con; Label5.Text = Convert.ToString(cmd1.ExecuteScalar()); } } } { if (lbus >= 500 && rbus >= 500) { Label15.Text = "Yes"; } { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from rewards where reward=4 and id=@ID"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd.Connection = con; if (Convert.ToInt64(cmd.ExecuteScalar()) >= 1) { Label16.Text = "Yes"; SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select convert(varchar,date_entry,106) from rewards where reward=4 and id=@ID"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd1.Connection = con; Label6.Text = Convert.ToString(cmd1.ExecuteScalar()); } } } { if (lbus >= 1000 && rbus >= 1000) { Label17.Text = "Yes"; } { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from rewards where reward=5 and id=@ID"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd.Connection = con; if (Convert.ToInt64(cmd.ExecuteScalar()) >= 1) { Label18.Text = "Yes"; SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select convert(varchar,date_entry,106) from rewards where reward=5 and id=@ID"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd1.Connection = con; Label7.Text = Convert.ToString(cmd1.ExecuteScalar()); } } } { if (lbus >= 2050 && rbus >= 2050) { Label19.Text = "Yes"; } { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from rewards where reward=6 and id=@ID"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd.Connection = con; if (Convert.ToInt64(cmd.ExecuteScalar()) >= 1) { Label20.Text = "Yes"; SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select convert(varchar,date_entry,106) from rewards where reward=6 and id=@ID"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd1.Connection = con; Label8.Text = Convert.ToString(cmd1.ExecuteScalar()); } } } { if (lbus >= 3200 && rbus >= 3200) { Label21.Text = "Yes"; } { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from rewards where reward=7 and id=@ID"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd.Connection = con; if (Convert.ToInt64(cmd.ExecuteScalar()) >= 1) { Label22.Text = "Yes"; SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select convert(varchar,date_entry,106) from rewards where reward=7 and id=@ID"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd1.Connection = con; Label25.Text = Convert.ToString(cmd1.ExecuteScalar()); } } } { if (lbus >= 10000 && rbus >= 10000) { Label23.Text = "Yes"; } { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from rewards where reward=8 and id=@ID"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd.Connection = con; if (Convert.ToInt64(cmd.ExecuteScalar()) >= 1) { Label24.Text = "Yes"; SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select convert(varchar,date_entry,106) from rewards where reward=8 and id=@ID"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd1.Connection = con; Label26.Text = Convert.ToString(cmd1.ExecuteScalar()); } } } { if (lbus >= 25000 && rbus >= 25000) { Label1.Text = "Yes"; } { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select count(*) from rewards where reward=9 and id=@ID"; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd.Connection = con; if (Convert.ToInt64(cmd.ExecuteScalar()) >= 1) { Label2.Text = "Yes"; SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "select convert(varchar,date_entry,106) from rewards where reward=9 and id=@ID"; cmd1.Parameters.Add("@ID", SqlDbType.VarChar).Value = Convert.ToString(Session["id"]); cmd1.Connection = con; Label27.Text = Convert.ToString(cmd1.ExecuteScalar()); } } } con.Dispose(); }