//Store lấy dữ liệu table
public DataTable tbPlan_GetList()
{
string procname = "tbPlan_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
//store chèn dữ liệu vào table
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@MaterialCode", MaterialCode);
db.AddParameter("@MaterialName", MaterialName);
if (Images == null)
{
db.AddParameter("@Images", DBNull.Value, "");
}
else
{
db.AddParameter("@Images", Images);
}
db.AddParameter("@Quota", Quota);
db.AddParameter("@Groups", Groups);
db.AddParameter("@Minimum", Minimum);
db.AddParameter("@Maximum", Maximum);
db.AddParameter("@Active", Active);
db.ExecuteNonQueryWithTransaction("tbMaterial_Insert");//thực thi store thêm
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
//Store lay du lieu
public DataTable tbDistributionDetails_GetList()
{
string procname = "tbDistributionDetails_GetList()";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
//store chèn dữ liệu vào table
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@SupplierCode", SupplierCode);
db.AddParameter("@SupplierName", SupplierName);
db.AddParameter("@Address", Address);
db.AddParameter("@Telephone", Telephone);
db.AddParameter("@Mail", Mail);
db.AddParameter("@Group", Group);
db.AddParameter("@Contact", Contact);
db.AddParameter("@Note", Note);
db.ExecuteNonQueryWithTransaction("tbSupplier_Insert");//thực thi store thêm
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
//edit du lieu tu ma kho
public DataTable tbStore_GetbyCode()
{
string procname = "tbStore_GetbyCode";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@StoreCode", StoreCode);
return db.ExecuteDataTable(procname);
}
public DataTable tbLogin_Get()
{
string procname = "tbLogin_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Username", Username);
db.AddParameter("@Password", Password);
return db.ExecuteDataTable(procname);
}
//Store xóa dữ liệu table
public bool Delete()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@MaterialCode", MaterialCode);// xóa dựa vào trường khóa
db.ExecuteNonQueryWithTransaction("tbMaterial_Delete");//thực thi store xóa
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
//Store cập nhật dữ liệu table
public bool Update()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@Username", Username);
db.AddParameter("@Password", Password);
db.ExecuteNonQueryWithTransaction("tbLogin_UpdatePass");//thực thi store sửa
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
//store chèn dữ liệu vào table
public bool Insert()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@StoreCode", StoreCode);
db.AddParameter("@StoreName", StoreName);
db.AddParameter("@Address", Address);
db.AddParameter("@Telephone", Telephone);
db.ExecuteNonQueryWithTransaction("tbStore_Insert");//thực thi store thêm
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
public DataTable tbMaterialDetails_GetByYear()
{
string procname = "tbMaterialDetails_GetByYear";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Years", Years);
return db.ExecuteDataTable(procname);
}
//Store cập nhật trạng thái
public bool UpdateStatus()
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@OrderCode", OrderCode);
db.AddParameter("@Status", Status);
db.ExecuteNonQueryWithTransaction("tbOrder_Status");//thực thi store
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
//Store cập nhật dữ liệu table
//update 2
public bool Update(DataTable dtOrderDetail, DataTable dtOrderDetailTemp)
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@OrderCode", OrderCode);
db.AddParameter("@DateSuggest", DateSuggest);
db.AddParameter("@Followers", Followers);
db.AddParameter("@SupplierCode", SupplierCode);
db.AddParameter("@DeliveryDate", DeliveryDate);
db.AddParameter("@PlaceOfDelivery", PlaceOfDelivery);
db.AddParameter("@PaymentConditions", PaymentConditions);
db.AddParameter("@VAT", VAT);
db.AddParameter("@CurrencyUnit", CurrencyUnit);
db.ExecuteNonQueryWithTransaction("tbOrder_Update");//begin thực thi store cập nhật dữ liệu
for (int i = 0; i < dtOrderDetail.Rows.Count; i++)
{
if (dtOrderDetail.Rows[i]["OrderDetailCode"] == DBNull.Value)//dua vao OrderDetailCode de them or sua
{
Describe = dtOrderDetail.Rows[i]["Describe"].ToString();
Number = int.Parse(dtOrderDetail.Rows[i]["Number"].ToString());
Unit = dtOrderDetail.Rows[i]["Unit"].ToString();
Price = double.Parse(dtOrderDetail.Rows[i]["Price"].ToString());
if (dtOrderDetail.Rows[i]["Monetize"] == DBNull.Value)
{
Monetize = 0;
}
else
{
Monetize = double.Parse(dtOrderDetail.Rows[i]["Monetize"].ToString());
}
SupplierSuggest = dtOrderDetail.Rows[i]["SupplierSuggest"].ToString();
db.CreateNewSqlCommand();
db.AddParameter("@OrderCode", OrderCode);
db.AddParameter("@Describe", Describe);
db.AddParameter("@Number", Number);
db.AddParameter("@Unit", Unit);
db.AddParameter("@Price", Price);
db.AddParameter("@Monetize", Monetize);
db.AddParameter("@SupplierSuggest", SupplierSuggest);
db.ExecuteNonQueryWithTransaction("tbOrderDetail_Insert");
}
else
{
OrderDetailCode =int.Parse(dtOrderDetail.Rows[i]["OrderDetailCode"].ToString());
Describe = dtOrderDetail.Rows[i]["Describe"].ToString();
Number = int.Parse(dtOrderDetail.Rows[i]["Number"].ToString());
Unit = dtOrderDetail.Rows[i]["Unit"].ToString();
Price = double.Parse(dtOrderDetail.Rows[i]["Price"].ToString());
if (dtOrderDetail.Rows[i]["Monetize"] == DBNull.Value)
{
Monetize = 0;
}
else
{
Monetize = double.Parse(dtOrderDetail.Rows[i]["Monetize"].ToString());
}
SupplierSuggest = dtOrderDetail.Rows[i]["SupplierSuggest"].ToString();
db.CreateNewSqlCommand();
db.AddParameter("@OrderDetailCode", OrderDetailCode);
//db.AddParameter("@OrderCode", OrderCode);
db.AddParameter("@Describe", Describe);
db.AddParameter("@Number", Number);
db.AddParameter("@Unit", Unit);
db.AddParameter("@Price", Price);
db.AddParameter("@Monetize", Monetize);
db.AddParameter("@SupplierSuggest", SupplierSuggest);
db.ExecuteNonQueryWithTransaction("tbOrderDetail_Update");
}
}
//xoa het du lieu bang OrderDetails truyen tu OrderDetailCode bang tam, chi chinh sua moi xoa
for (int i = 0; i < dtOrderDetailTemp.Rows.Count; i++)
{
OrderDetailCode = int.Parse(dtOrderDetailTemp.Rows[i]["OrderDetailCode"].ToString());
db.CreateNewSqlCommand();
db.AddParameter("@OrderDetailCode", OrderDetailCode);
db.ExecuteNonQueryWithTransaction("tbOrderDetail_Delete");
}
db.CommitTransaction();//end
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
public DataTable tbOrder_GetAutocode()
{
string procname = "tbOrder_GetAutocode";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Year", Year);
return db.ExecuteDataTable(procname);
}
public DataTable tbOrder_Get()
{
string procname = "tbOrder_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@OrderCode", OrderCode);
return db.ExecuteDataTable(procname);
}
public DataTable tbOrderDetails_FindOrder()
{
string procname = "tbOrderDetails_FindOrder";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Describe", Describe);
return db.ExecuteDataTable(procname);
}
//store chèn dữ liệu vào table
public bool Insert(DataTable dtOrderDetail)
{
DbAccess db = new DbAccess();
db.BeginTransaction();
try
{
db.CreateNewSqlCommand();
db.AddParameter("@OrderCode", OrderCode);
db.AddParameter("@DateSuggest", DateSuggest);
db.AddParameter("@Followers", Followers);
db.AddParameter("@SupplierCode", SupplierCode);
db.AddParameter("@DeliveryDate", DeliveryDate);
db.AddParameter("@PlaceOfDelivery", PlaceOfDelivery);
db.AddParameter("@PaymentConditions", PaymentConditions);
db.AddParameter("@VAT", VAT);
db.AddParameter("@CurrencyUnit", CurrencyUnit);
db.ExecuteNonQueryWithTransaction("tbOrder_Insert");//thực thi store chèn
for (int i = 0; i < dtOrderDetail.Rows.Count; i++)
{
Describe = dtOrderDetail.Rows[i]["Describe"].ToString();
Number = int.Parse(dtOrderDetail.Rows[i]["Number"].ToString());
Unit = dtOrderDetail.Rows[i]["Unit"].ToString();
Price = double.Parse(dtOrderDetail.Rows[i]["Price"].ToString());
if (dtOrderDetail.Rows[i]["Monetize"] == DBNull.Value)
{
Monetize = 0;
}else
{
Monetize = double.Parse(dtOrderDetail.Rows[i]["Monetize"].ToString());
}
SupplierSuggest = dtOrderDetail.Rows[i]["SupplierSuggest"].ToString();
db.CreateNewSqlCommand();
db.AddParameter("@OrderCode", OrderCode);
db.AddParameter("@Describe", Describe);
db.AddParameter("@Number", Number);
db.AddParameter("@Unit", Unit);
db.AddParameter("@Price", Price);
db.AddParameter("@Monetize", Monetize);
db.AddParameter("@SupplierSuggest", SupplierSuggest);
db.ExecuteNonQueryWithTransaction("tbOrderDetail_Insert");
}
db.CommitTransaction();
return true;
}
catch
{
db.RollbackTransaction();
return false;
}
}
