public static int InsertDataBillGridMasterReturnId(DataObject.BillGridMasterDB obj)
{
String Insert = "INSERT INTO BillGridMasterDB (Master,billType,billTypeId,OrderType,OrderTypeId,OrderType2Id,dateShip,discount,monny,payType,payTypeId,stt,billId,customerId) VALUES ";
Insert += " (@Master,@billType,@billTypeId,@OrderType,@OrderTypeId,@OrderType2Id,@dateShip,@discount,@monny,@payType,@payTypeId,@stt,@billId,@customerId)";
SqlConnection conn = Common.Connection.SqlConnect();
SqlCommand cmd = new SqlCommand(Insert);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@Master", obj.Master);
cmd.Parameters.AddWithValue("@billType", obj.billType);
cmd.Parameters.AddWithValue("@billTypeId", obj.billTypeId);
cmd.Parameters.AddWithValue("@OrderType", obj.OrderType);
cmd.Parameters.AddWithValue("@OrderTypeId", obj.OrderTypeId);
cmd.Parameters.AddWithValue("@OrderType2Id", obj.OrderType2Id);
cmd.Parameters.AddWithValue("@dateShip", obj.dateShip);
cmd.Parameters.AddWithValue("@discount", obj.discount);
cmd.Parameters.AddWithValue("@monny", obj.monny);
cmd.Parameters.AddWithValue("@payType", obj.payType);
cmd.Parameters.AddWithValue("@payTypeId", obj.payTypeId);
cmd.Parameters.AddWithValue("@stt", obj.stt);
cmd.Parameters.AddWithValue("@billId", obj.billId);
cmd.Parameters.AddWithValue("@customerId", obj.customerId);
conn.Open();
cmd.ExecuteNonQuery();
cmd.CommandText = "SELECT scope_identity()";
int identity = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
return(identity);
}
public static List <DataObject.BillGridMasterDB> GetDataBillGridMasterDB(Int32 Id)
{
List <DataObject.BillGridMasterDB> lstGridMasterDB = new List <DataObject.BillGridMasterDB>();
String Select = "";
SqlCommand cmd = null;
SqlConnection conn = Common.Connection.SqlConnect();
if (Id > 0)
{
Select = "Select * from BillGridMasterDB Where ID = @ID";
cmd = new SqlCommand(Select);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@ID", Id);
}
else
{
Select = "Select * from BillGridMasterDB";
cmd = new SqlCommand(Select);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
}
conn.Open();
using (SqlDataReader oReader = cmd.ExecuteReader())
{
while (oReader.Read())
{
// Master,billType,billTypeId,OrderType,OrderTypeId,OrderType2Id,dateShip,discount,monny,payType,payTypeId,stt,billId,customerId
DataObject.BillGridMasterDB obj = new DataObject.BillGridMasterDB();
obj.ID = Int32.Parse(oReader["ID"].ToString());
obj.Master = (bool)(oReader["Master"]);
obj.billType = oReader["billType"].ToString();
obj.billTypeId = oReader["billTypeId"].ToString();
obj.OrderType = oReader["OrderType"].ToString();
obj.OrderTypeId = oReader["OrderTypeId"].ToString();
obj.OrderType2Id = oReader["OrderType2Id"].ToString();
obj.dateShip = oReader["dateShip"].ToString();
obj.discount = oReader["discount"].ToString();
obj.monny = oReader["monny"].ToString();
obj.payType = oReader["payType"].ToString();
obj.payTypeId = oReader["payTypeId"].ToString();
obj.stt = Int32.Parse(oReader["stt"].ToString());
obj.billId = Int32.Parse(oReader["billId"].ToString());
obj.customerId = Int32.Parse(oReader["customerId"].ToString());
lstGridMasterDB.Add(obj);
}
}
conn.Close();
return(lstGridMasterDB);
}
