public static int InsertDataReturnId(DataObject.SysBillDetailVertical obj) { String Insert = "INSERT INTO SYS_BILL_DETAIL_VERTICAL (VerticalMasterBill_ID,ProductCode,Quantity,ProductId,ProductPrice,IsSugar,TotalAmount,PromotionCode,Total,Comment) VALUES "; Insert += " (@VerticalMasterBill_ID,@ProductCode,@Quantity,@ProductId,@ProductPrice,@IsSugar,@TotalAmount,@PromotionCode,@Total,@Comment)"; SqlConnection conn = Common.Connection.SqlConnect(); SqlCommand cmd = new SqlCommand(Insert); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@VerticalMasterBill_ID", obj.VerticalMasterBill_ID); cmd.Parameters.AddWithValue("@ProductCode", obj.ProductCode); cmd.Parameters.AddWithValue("@Quantity", obj.Quantity); cmd.Parameters.AddWithValue("@ProductId", obj.ProductId); cmd.Parameters.AddWithValue("@ProductPrice", obj.ProductPrice); cmd.Parameters.AddWithValue("@IsSugar", obj.IsSugar); cmd.Parameters.AddWithValue("@TotalAmount", obj.TotalAmount); cmd.Parameters.AddWithValue("@Total", obj.Total); cmd.Parameters.AddWithValue("@Comment", obj.Comment); cmd.ExecuteNonQuery(); cmd.CommandText = "SELECT scope_identity()"; conn.Open(); int identity = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(identity); }
public static void UpdateData(DataObject.SysBillDetailVertical obj) { SqlConnection conn = Common.Connection.SqlConnect(); String Update = "UPDATE SYS_BILL_DETAIL_VERTICAL SET VerticalMasterBill_ID = @VerticalMasterBill_ID, ProductCode = @ProductCode "; Update += " @Quantity = Quantity, "; Update += " @ProductId = ProductId, @ProductPrice = ProductPrice, @IsSugar = IsSugar, "; Update += " @TotalAmount = TotalAmount, "; Update += " @PromotionCode = PromotionCode, "; Update += " @Total = Total, @Comment = Comment, "; Update += " Where ID = @ID"; SqlCommand cmd = new SqlCommand(Update); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@VerticalMasterBill_ID", obj.VerticalMasterBill_ID); cmd.Parameters.AddWithValue("@ProductCode", obj.ProductCode); cmd.Parameters.AddWithValue("@Quantity", obj.Quantity); cmd.Parameters.AddWithValue("@ProductId", obj.ProductId); cmd.Parameters.AddWithValue("@ProductPrice", obj.ProductPrice); cmd.Parameters.AddWithValue("@IsSugar", obj.IsSugar); cmd.Parameters.AddWithValue("@TotalAmount", obj.TotalAmount); cmd.Parameters.AddWithValue("@Total", obj.Total); cmd.Parameters.AddWithValue("@Comment", obj.Comment); cmd.Parameters.AddWithValue("@ID", obj.ID); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static List <DataObject.SysBillDetailVertical> GetData(Int32 Id) { List <DataObject.SysBillDetailVertical> lstSysBillDetailVertical = new List <DataObject.SysBillDetailVertical>(); String Select = ""; SqlCommand cmd = null; SqlConnection conn = Common.Connection.SqlConnect(); if (Id > 0) { Select = "Select * from SYS_BILL_DETAIL_VERTICAL Where VerticalMasterBill_ID = @ID"; cmd = new SqlCommand(Select); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@ID", Id); } else { Select = "Select * from SYS_BILL_DETAIL_VERTICAL"; cmd = new SqlCommand(Select); cmd.CommandType = CommandType.Text; cmd.Connection = conn; } conn.Open(); using (SqlDataReader oReader = cmd.ExecuteReader()) { while (oReader.Read()) { DataObject.SysBillDetailVertical obj = new DataObject.SysBillDetailVertical(); obj.ID = Int32.Parse(oReader["ID"].ToString()); obj.VerticalMasterBill_ID = Int32.Parse(oReader["VerticalMasterBill_ID"].ToString()); obj.ProductCode = oReader["ProductCode"].ToString(); obj.Quantity = Int32.Parse(oReader["Quantity"].ToString()); obj.ProductId = Int32.Parse(oReader["ProductId"].ToString()); obj.ProductPrice = Int32.Parse(oReader["ProductPrice"].ToString()); obj.IsSugar = (bool)oReader["IsSugar"]; obj.TotalAmount = float.Parse(oReader["TotalAmount"].ToString()); obj.PromotionCode = oReader["PromotionCode"].ToString(); obj.Total = float.Parse(oReader["Total"].ToString()); obj.Comment = oReader["Comment"].ToString(); lstSysBillDetailVertical.Add(obj); } } conn.Close(); return(lstSysBillDetailVertical); }