protected void Page_Load(object sender, EventArgs e) { //測試用 //DIALOG_USER data_User = SQLFunc.Get_DIALOG_USER("1", "Athena", "192.168.7.127", "2017-03-23 14:29:15.647"); //Session["DIALOG_USER"] = data_User; if (!IsPostBack) { txt_Sentence.Attributes.Add("onkeydown", "if(event.keyCode == 13) {document.getElementById('" + btn_Submit.ClientID + "').click(); return false;}"); } if (Session["DIALOG_USER"] == null) { Response.Redirect("Login.aspx"); } else { MotionClass.DIALOG_USER DIALOG_USER = (MotionClass.DIALOG_USER)Session["DIALOG_USER"]; if (Request["DM_ID"] == null) { Response.Redirect("Login.aspx"); } else { string DM_ID = Request["DM_ID"].ToString(); DataTable dt = SQLFunc.Get_DIALOG_MAIN(DM_ID); Page_Bind(dt); ll_Name.Text = DIALOG_USER.U_Name; } } //ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "scrollTo", "window.scrollTo(0,document.body.scrollHeight);alert('aa');", true); }
protected void Page_Load(object sender, EventArgs e) { //測試用 MotionClass.DIALOG_USER DIALOG_USER = (MotionClass.DIALOG_USER)Session["DIALOG_USER"]; Session["DIALOG_USER"] = DIALOG_USER; if (Session["dialog_user"] == null) { Response.Redirect("Login.aspx"); } else { // DIALOG_USER DIALOG_USER = (DIALOG_USER)Session["DIALOG_USER"]; // if (Request["DM_ID"] == null) // { // Response.Redirect("../Default.aspx"); // } // else // { // string DM_ID = Request["DM_ID"].ToString(); // DataTable dt = SQLFunc.Get_DIALOG_MAIN(DM_ID); // Page_Bind(dt); // ll_Name.Text = DIALOG_USER.U_Name; // } } //ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "scrollTo", "window.scrollTo(0,document.body.scrollHeight);alert('aa');", true); }
public static MotionClass.DIALOG_USER Get_DIALOG_USER(string U_ID, string U_Name, string U_IP, string U_CreateTime) { MotionClass.DIALOG_USER data = new MotionClass.DIALOG_USER(); data.U_ID = U_ID; data.U_Name = U_Name; data.U_IP = U_IP; data.U_CreateTime = U_CreateTime; return(data); }
public static string Add_DIALOG_USER(MotionClass.DIALOG_USER data) { var cmd = new SqlCommand(); cmd.CommandText = "Insert into DIALOG_USER (U_IP, U_Name, U_CreateTime) values (@U_IP, @U_Name, @U_CreateTime) "; cmd.Parameters.Add("U_IP", SqlDbType.NVarChar).Value = data.U_IP; cmd.Parameters.Add("U_Name", SqlDbType.NVarChar).Value = data.U_Name; cmd.Parameters.Add("U_CreateTime", SqlDbType.NVarChar).Value = data.U_CreateTime; cmd.CommandText += "select @@IDENTITY "; DataTable dt = Persister.Execute(cmd); string id = dt.Rows[0][0].ToString(); return(id); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { txt_Name.Attributes.Add("onkeydown", "if(event.keyCode == 13) {document.getElementById('" + btn_Save.ClientID + "').click(); return false;}"); string ip_string = GetClientIP(); lb_IP.Text = ip_string; DataTable dt = SQLFunc.Get_DIALOG_USER(ip_string); if (dt.Rows.Count > 0) { txt_Name.Text = dt.Rows[0]["U_Name"].ToString(); hid_U_ID.Value = dt.Rows[0]["U_ID"].ToString(); MotionClass.DIALOG_USER data = SQLFunc.Get_DIALOG_USER(dt.Rows[0]["U_ID"].ToString(), dt.Rows[0]["U_Name"].ToString(), dt.Rows[0]["U_IP"].ToString(), dt.Rows[0]["U_CreateTime"].ToString()); Session["DIALOG_USER"] = data; } else { Session.Clear(); } } }
protected void btn_Save_Click(object sender, EventArgs e) { MotionClass.DIALOG_USER data = null; string now_date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); string name = txt_Name.Text; if (string.IsNullOrEmpty(name)) { Alert_msg("交出名字,饒你一命"); } else { if (name == "gis@5200") { data = SQLFunc.Get_DIALOG_USER("", "Manager", lb_IP.Text, now_date); Session["DIALOG_USER"] = data; Response.Redirect("~/Page/Summary.aspx"); } else { if (Session["DIALOG_USER"] == null) { data = SQLFunc.Get_DIALOG_USER("", name, lb_IP.Text, now_date); string U_ID = SQLFunc.Add_DIALOG_USER(data); data = SQLFunc.Get_DIALOG_USER(U_ID, name, lb_IP.Text, now_date); Session["DIALOG_USER"] = data; } MotionClass.DIALOG_USER data_USER = (MotionClass.DIALOG_USER)Session["DIALOG_USER"]; MotionClass.DIALOG_MAIN data_Main = SQLFunc.Get_DIALOG_MAIN(data_USER.U_ID, "0", now_date); string DM_ID = SQLFunc.Add_DIALOG_MAIN(data_Main); //string DM_ID = "1"; Response.Redirect("Page/Dialog.aspx?DM_ID=" + DM_ID); } } }