public static List <TransactionDetail> GetListByServerResponse(string response) { if (response == "") { return(null); } List <TransactionDetail> members = new List <TransactionDetail>(); string[] lines = response.Split(new string[] { "<BR>" }, StringSplitOptions.None); foreach (string line in lines) { if (line.Trim() == "") { continue; } string[] datas = line.Split(';'); TransactionDetail m = new TransactionDetail(); m.trdetail_id = Convert.ToInt32(datas[0].Trim()); m.transaction_id = Convert.ToInt32(datas[1].Trim()); m.menu_id = Convert.ToInt32(datas[2].Trim()); m.menu_name = datas[3]; m.tr_unit = Convert.ToInt32(datas[4].Trim()); m.tr_unit_price = Convert.ToDecimal(datas[5].Trim()); m.tr_total_price = Convert.ToDecimal(datas[6].Trim()); members.Add(m); } return(members); }
public static string GetInsertSQL(TransactionDetail tr) { return(@"INSERT INTO transactiondetail (transaction_id ,menu_id ,menu_name ,tr_unit ,tr_unit_price ,tr_total_price ) VALUES ('" + tr.transaction_id + @"' ,'" + tr.menu_id + @"' ,'" + tr.menu_name + @"' ,'" + tr.tr_unit + @"' ,'" + tr.tr_unit_price + @"' ,'" + tr.Tr_total_price + @"')"); }