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 ｅ)
{
miceData.ReturnCode = "S899";
miceData.ReturnMessage = "載入老鼠資料例外情況！";
throw ｅ;
}
return(miceData); //回傳資料
}
