/// <summary> /// 查询行dengdeng /// </summary> private void GetRow() { string errmsg = ""; string data = Request["data"]; DataTable dt = new DataTable(); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); DataTable dt4 = new DataTable(); DataTable dt5 = new DataTable(); RequestRow info = ObjectSerializeHelper.JsonToObject <RequestRow>(data); string pagecode = info.pagecode; string usercode = info.usercode; string nowrow = info.nowrow; BLLUserManage mybll = new BLLUserManage(); bool result = mybll.GetRow(pagecode, usercode, nowrow, ref dt, ref dt1, ref dt2, ref dt3, ref dt4, ref dt5, ref errmsg); if (!result) { Response.Write(outjson.Replace("#code#", "-1").Replace("#msg#", errmsg)); Response.End(); } else { string json = "\"data\":" + ObjectSerializeHelper.DataTableToJson(dt, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data1\":" + ObjectSerializeHelper.DataTableToJson(dt1, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data2\":" + ObjectSerializeHelper.DataTableToJson(dt2, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data3\":" + ObjectSerializeHelper.DataTableToJson(dt3, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data4\":" + ObjectSerializeHelper.DataTableToJson(dt4, ObjectSerializeHelper.ColumnNameLetterCase.ToLower) + ",\"data5\":" + ObjectSerializeHelper.DataTableToJson(dt5, ObjectSerializeHelper.ColumnNameLetterCase.ToLower); Response.Write(outjson.Replace("#code#", "0").Replace("#msg#", "").Replace("\"data\":null", json)); Response.End(); } }
// Use this for initialization void Start() { entries.Clear(); using (SqliteCommand command = new SqliteCommand(Database.DB)) { command.CommandText = string.Format("SELECT " + "(SELECT full_name FROM users WHERE users.username = leaves.username) AS name, " + "timestamp, status, dates " + "FROM leaves WHERE approving = \"{0}\"", User.username); using (SqliteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { RequestRow row = new RequestRow(); row.name = reader["name"].ToString(); row.timestamp = reader["timestamp"].ToString(); row.status = reader["status"].ToString(); row.dates = reader["dates"].ToString(); var entry = Instantiate(entryPrefab, content).GetComponent <LeaveRequestEntry>(); entry.Init(row); entries.Add(entry); } } } }
public JoinTable(List <JoinRequest> requests) { this.requests = requests; foreach (JoinRequest request in requests) { RequestRow row = new RequestRow(request); TableCell cellUserName = new TableCell(); TextBox userNameTextBox = new TextBox(); userNameTextBox.Text = request.User.UserName; userNameTextBox.ReadOnly = true; cellUserName.Controls.Add(userNameTextBox); row.Controls.Add(cellUserName); TableCell cellCharName = new TableCell(); TextBox charNameTextBox = new TextBox(); charNameTextBox.Text = request.PartyMember.Name; charNameTextBox.ReadOnly = true; cellCharName.Controls.Add(charNameTextBox); row.Controls.Add(cellCharName); TableCell cellCharRace = new TableCell(); TextBox charRaceTextBox = new TextBox(); charRaceTextBox.Text = request.PartyMember.Race; charRaceTextBox.ReadOnly = true; cellCharRace.Controls.Add(charRaceTextBox); row.Controls.Add(cellCharRace); TableCell cellCharPerc = new TableCell(); TextBox charPercTextBox = new TextBox(); charPercTextBox.Text = request.PartyMember.Perception.ToString(); charPercTextBox.ReadOnly = true; cellCharPerc.Controls.Add(charPercTextBox); row.Controls.Add(cellCharPerc); TableCell cellCharHP = new TableCell(); TextBox charHPTextBox = new TextBox(); charHPTextBox.Text = request.PartyMember.MaxHP.ToString(); charHPTextBox.ReadOnly = true; cellCharHP.Controls.Add(charHPTextBox); row.Controls.Add(cellCharHP); TableCell cellCharSize = new TableCell(); TextBox charSizeTextBox = new TextBox(); charSizeTextBox.Text = request.PartyMember.Size.ToString(); charSizeTextBox.ReadOnly = true; cellCharSize.Controls.Add(charSizeTextBox); row.Controls.Add(cellCharSize); TableCell cellAccept = new TableCell(); Button acceptButton = new Button(); acceptButton.Text = "Accept"; acceptButton.CssClass = "fullWidth"; acceptButton.Click += new EventHandler(acceptButtonClicked); cellAccept.Controls.Add(acceptButton); row.Controls.Add(cellAccept); TableCell cellDeny = new TableCell(); Button denyButton = new Button(); denyButton.Text = "Deny"; denyButton.CssClass = "fullWidth"; denyButton.Click += new EventHandler(denyButtonClicked); cellDeny.Controls.Add(denyButton); row.Controls.Add(cellDeny); this.Controls.Add(row); } }