public static string getAuth() { string result = ""; result = DB_data.getAuth(); return(result); }
public static string Init(DataSolo G_no) { string result = ""; result = DB_data.Init(G_no.ID); return(result); }
public static string Save(List <Data> postData, DataSolo G_no) { string result = ""; DB_data.AuthDel(G_no.ID); foreach (Data _postData in postData) { if (DB_data.AuthBtnsave(G_no.ID, _postData.ID) == "{\"Type\": \"失敗\"}") { result = "{\"Type\": \"失敗\"}"; return(result); } } result = "{\"Type\": \"成功\"}"; return(result); }
public void DescendData(ref DB_data[] datas) { //데이터를 스코어 순으로 내림차순 정렬한다. (버블정렬아님) for (int i = 0; i < datas.Length - 1; i++) { for (int j = i + 1; j < datas.Length; j++) { if (int.Parse(datas[i].Score) < int.Parse(datas[j].Score)) { tmp = datas[i]; datas[i] = datas[j]; datas[j] = tmp; } } } }
protected void save_Click() { List <string> Lstr = new List <string>(); //暫存 勾起來的value foreach (GridViewRow gdrw in Grid_Auth.Rows) { CheckBox Choose = (CheckBox)gdrw.Cells[0].FindControl("Choose"); if (Choose.Checked == true) { Lstr.Add(gdrw.Cells[1].Text); } } DB_data.AuthDel(id.Value);//刪明細 foreach (string str in Lstr) { DB_data.AuthBtnsave(id.Value, str); } Response.Redirect("Auth.aspx?type=auth"); }
public IEnumerator LoadDB(string _url) { WWWForm tForm = new WWWForm(); //php로 전송할 데이터를 같이 포함시킨다. //php에선 $_POST["db_host"]; 의 형태로 받는다. //tForm.AddField("id", "TEST"); tForm.AddField("DBQuery", (int)dbQuery); switch (dbQuery) { case eDBQuery.INSERT_UPDATE: tForm.AddField("users", datas.username); tForm.AddField("timeleft", datas.cleartime); tForm.AddField("score", datas.score); //tForm.AddField("mission", datas.mission); break; case eDBQuery.RANK1: break; case eDBQuery.RANK2: break; case eDBQuery.RANK3: break; case eDBQuery.SELECTALL: break; } WWW www = new WWW(_url, tForm); //php를 호출 yield return(www); //응답이 돌아올때까지 대기한다. 이 대기시간 때문에 코루틴으로 진행한다. //Debug.Log(www.text); if (www.error != null) //php 접근 자체에 문제가 있으면 www.error가 발생한다. { Debug.Log("www에러" + www.error); } else { //Debug.Log(www.text); string result = www.text; ArrayList list = new ArrayList(); JObject jo = JObject.Parse(result); Debug.Log(jo); //SELECT * 나오는값 //RANK 값 //나중에 디비쿼리 추가할수도있으니 케이스문으로 관리하는게좋ㅇ륻ㅅ JArray ja = JArray.Parse(jo["result"].ToString()); foreach (JObject jobj in ja) { DB_data date_slice = new DB_data(); date_slice.Users = jobj["users"].ToString(); date_slice.Timeleft = jobj["timeleft"].ToString(); date_slice.today = jobj["today"].ToString(); date_slice.Score = jobj["score"].ToString(); list.Add(date_slice); } switch (dbQuery) { case eDBQuery.RANK1: foreach (DB_data u in list) { test[inum * 4 - 4].text = u.Users; test[inum * 4 - 3].text = u.Timeleft; test[inum * 4 - 2].text = u.today; test[inum * 4 - 1].text = u.Score; inum++; } break; case eDBQuery.RANK2: foreach (DB_data u in list) { test[inum * 4 - 4].text = u.Users; test[inum * 4 - 3].text = u.Timeleft; test[inum * 4 - 2].text = u.today; test[inum * 4 - 1].text = u.Score; inum++; } break; case eDBQuery.RANK3: foreach (DB_data u in list) { test[inum * 4 - 4].text = u.Users; test[inum * 4 - 3].text = u.Timeleft; test[inum * 4 - 2].text = u.today; test[inum * 4 - 1].text = u.Score; inum++; } break; case eDBQuery.SELECTALL: foreach (DB_data u in list) { //print("user = "******" / timeleft = " + u.Timeleft + " / score = " + u.Score + " / today = " + u.today ); } break; } //foreach (DB_data u in list) //{ // print("user = "******" / timeleft = " + u.Timeleft + " / score = " + u.Score + " / today = " + u.today + " / mission = " + u.mission); //} } }