private ShopCarData GetShopCarData(string iPID, ShopCarData[] iData)
{
ShopCarData TempData = new ShopCarData();
for (int i = 0; i < iData.Length; i++)
{
if (iPID == iData[i].ID)
{
TempData = iData[i];
return(TempData);
}
}
return(TempData);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string aJsonDataStr = Request["JsonData"].ToString();
ShopCarData aShopCarData = JsonConvert.DeserializeObject <ShopCarData>(aJsonDataStr);
HttpCookie aAccountCookie = Request.Cookies["Account"];
string aAccount = aAccountCookie.Value;
HttpCookie aCookie = Request.Cookies[aAccount];
//取得cookie字串
string aCookieData = aCookie.Value;
//把資料分隔開來
string[] aNewContent = aCookieData.Split(Convert.ToChar(','));
//重新給陣列大小
Array.Resize(ref mProductID, aNewContent.Length);
Array.Resize(ref mProductCount, aNewContent.Length);
for (int i = 0; i < aNewContent.Length; i++)
{
string[] aTemp = aNewContent[i].Split(Convert.ToChar('|'));
mProductID[i] = aTemp[0];
mProductCount[i] = aTemp[1];
}
//開始寫入SQL
try
{
string aStr = "INSERT INTO BuyData(ProductID,ProductCount,CardNumber,Password,BuyAddress,BuyName,BuyPhone,GetName,GetPhone,GetAddress,UserAccount,SingleNumber,RecTime) VALUES('{0}','{1}','{2}','{3}',N'{4}',N'{5}','{6}',N'{7}','{8}',N'{9}','{10}','{11}','{12}')";
using (SqlConnection vCon = new SqlConnection("Data Source=184.168.47.10;Integrated Security=False;User ID=MobileDaddy;PASSWORD=Aa54380438!;Connect Timeout=15;Encrypt=False;Packet Size=4096"))
{
vCon.Open();
string aSingleNumber = GetSingleNumber();
string aRecTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
for (int i = 0; i < mProductID.Length; i++)
{
string aBuyAddress = GetAddress(aShopCarData.BuyAddressCity, aShopCarData.BuyAddressArea, aShopCarData.BuyAddress);
string aGetAddress = GetAddress(aShopCarData.GetAddressCity, aShopCarData.GetAddressArea, aShopCarData.GetAddress);
string aSQLStr = string.Format(aStr, mProductID[i], mProductCount[i], aShopCarData.CardNumber, aShopCarData.Password, aBuyAddress, aShopCarData.BuyName, aShopCarData.BuyPhone, aShopCarData.GetName, aShopCarData.GetPhone, aGetAddress, aAccount, aSingleNumber, aRecTime);
using (SqlCommand vCmd = new SqlCommand(aSQLStr, vCon))
{
vCmd.ExecuteNonQuery();
}
}
}
Response.Write("1");
}
catch
{
}
}
catch
{
Response.Write("2");
}
}
