public static int InsertDataDetailMasterGridReturnId(DataObject.DetailMasterGrid obj)
{
String Insert = "INSERT INTO DetailMasterGrid (parent,parentBillId,parentId,deliveryDate,product,sugar,quantity,price,money,promotionCode,total,test,operate) VALUES ";
Insert += " (@parent,@parentBillId,@parentId,@deliveryDate,@product,@sugar,@quantity,@price,@money,@promotionCode,@total,@test,@operate)";
SqlConnection conn = Common.Connection.SqlConnect();
SqlCommand cmd = new SqlCommand(Insert);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@parent", obj.parent);
cmd.Parameters.AddWithValue("@parentBillId", obj.parentBillId);
cmd.Parameters.AddWithValue("@deliveryDate", obj.deliveryDate);
cmd.Parameters.AddWithValue("@product", obj.product);
cmd.Parameters.AddWithValue("@sugar", obj.sugar);
cmd.Parameters.AddWithValue("@quantity", obj.quantity);
cmd.Parameters.AddWithValue("@price", obj.price);
cmd.Parameters.AddWithValue("@money", obj.money);
cmd.Parameters.AddWithValue("@promotionCode", obj.promotionCode);
cmd.Parameters.AddWithValue("@total", obj.total);
cmd.Parameters.AddWithValue("@test", obj.test);
cmd.Parameters.AddWithValue("@operate", obj.operate);
conn.Open();
cmd.ExecuteNonQuery();
/*
* cmd.CommandText = "SELECT scope_identity()";
* int identity = Convert.ToInt32(cmd.ExecuteScalar());
* */
conn.Close();
return(1);
}
public static List <DataObject.DetailMasterGrid> GetDetailMasterGrid(Int32 Id)
{
List <DataObject.DetailMasterGrid> lstGridMasterDB = new List <DataObject.DetailMasterGrid>();
String Select = "";
SqlCommand cmd = null;
SqlConnection conn = Common.Connection.SqlConnect();
if (Id > 0)
{
Select = "Select * from DetailMasterGrid Where ID = @ID";
cmd = new SqlCommand(Select);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@ID", Id);
}
else
{
Select = "Select * from DetailMasterGrid";
cmd = new SqlCommand(Select);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
}
conn.Open();
using (SqlDataReader oReader = cmd.ExecuteReader())
{
while (oReader.Read())
{
// parent,parentBillId,parentId,deliveryDate,product,sugar,quantity,price,money,promotionCode,total,test,operate
DataObject.DetailMasterGrid obj = new DataObject.DetailMasterGrid();
obj.ID = Int32.Parse(oReader["ID"].ToString());
obj.parent = (bool)(oReader["parent"]);
obj.parentBillId = Int32.Parse(oReader["parentBillId"].ToString());
obj.parentId = Int32.Parse(oReader["parentId"].ToString());
obj.deliveryDate = oReader["deliveryDate"].ToString();
obj.product = oReader["product"].ToString();
obj.sugar = Int32.Parse(oReader["sugar"].ToString());
obj.quantity = oReader["quantity"].ToString();
obj.price = oReader["price"].ToString();
obj.money = oReader["money"].ToString();
obj.promotionCode = oReader["promotionCode"].ToString();
obj.total = oReader["total"].ToString();
obj.test = oReader["test"].ToString();
obj.operate = oReader["operate"].ToString();
lstGridMasterDB.Add(obj);
}
}
conn.Close();
return(lstGridMasterDB);
}
