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); }