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