public byte[] LoadMiceData() { MiceData miceData = new MiceData(); miceData.ReturnCode = "S800"; miceData.ReturnMessage = ""; try { MiceDataLogic miceDataLogic = new MiceDataLogic(); miceData = miceDataLogic.LoadMiceData(); } catch (Exception e) { miceData.ReturnCode = "S800"; miceData.ReturnMessage = e.Message; } return(TextUtility.SerializeToStream(miceData)); }
public MiceData LoadMiceData() { MiceData miceData = new MiceData(); miceData.ReturnCode = "S800"; miceData.ReturnMessage = ""; DataSet DS = new DataSet(); try { // 把引號'變成''以防止隱碼攻擊 //Account = Account.Replace("'", "''"); //Password = Password.Replace("'", "''"); using (SqlConnection sqlConn = new SqlConnection(connectionString)) { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlConn; sqlConn.Open(); Log.Debug("連線資訊 :" + sqlConn.ToString()); // 讀取老鼠資料 寫入DS資料列 SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand("SELECT * FROM Monster_MiceData", sqlConn); adapter.Fill(DS); } // 若有讀到則 取得所有資料 if (DS.Tables[0].Rows.Count > 0) { int i = 0, j = 0; foreach (DataTable table in DS.Tables) { Dictionary <string, object> dictData = new Dictionary <string, object>(); string itemID = ""; foreach (DataRow row in table.Rows) { j = 0; Dictionary <string, object> dictData2 = new Dictionary <string, object>(); foreach (DataColumn col in table.Columns) { if (j == 0) { itemID = table.Rows[i][col].ToString(); } dictData2.Add(col.ColumnName, table.Rows[i][col].ToString()); j++; } dictData.Add(itemID, dictData2); i++; } miceData.miceProperty = Json.Serialize(dictData); } miceData.ReturnCode = "S801"; //true } else { miceData.ReturnCode = "S802"; miceData.ReturnMessage = "取得老鼠資料失敗!"; } } catch (Exception e) { miceData.ReturnCode = "S899"; miceData.ReturnMessage = "載入老鼠資料例外情況!"; throw e; } return(miceData); //回傳資料 }