/// <summary>
/// Insert đối tượng vào database
/// </summary>
/// <param name="menu"></param>
/// <returns></returns>
public string Insert(LogProductexportContract logproductexport, SqlTransaction tran = null)
{
DataTable dtResult = null;
string query = string.Format(@"INSERT INTO Log_ProductExport
VALUES ({0},{1},{2},{3},convert(datetime,{4},103),{5},{6},{7})",
(logproductexport.Storeid.Trim() != String.Empty ? logproductexport.Storeid.ToString() : "null").ToString(),
(logproductexport.Productid.Trim() != String.Empty ? logproductexport.Productid.ToString() : "null").ToString(),
(logproductexport.Importcode.Trim() != String.Empty? "N'" + SQLHelper.RejectInjection(logproductexport.Importcode.ToString()) + "'" : "null").ToString(),
(logproductexport.Quantity.Trim() != String.Empty ? logproductexport.Quantity.ToString() : "null").ToString(),
(logproductexport.Exportdate != null? "'" + SQLHelper.RejectInjection(logproductexport.Exportdate.ToString()) + "'" : "null").ToString(),
(logproductexport.Exportcode.Trim() != String.Empty? "N'" + SQLHelper.RejectInjection(logproductexport.Exportcode.ToString()) + "'" : "null").ToString(),
(logproductexport.Importprice.Trim() != String.Empty ? logproductexport.Importprice.ToString() : "null").ToString(),
(logproductexport.Exportprice.Trim() != String.Empty ? logproductexport.Exportprice.ToString() : "null").ToString());
query += " ; select SCOPE_IDENTITY();";
if (tran == null)
{
dtResult = DataProvider.ExecuteQuery(query);
}
else
{
dtResult = DataProvider.ExecuteQueryWithTransaction(query, tran);
}
if (dtResult != null && dtResult.Rows.Count > 0)
{
return(dtResult.Rows[0][0].ToString());
}
return("");
}
public static string Export(string storeId, string exportCode, int quantity, string productId, SqlTransaction tran)
{
try
{
DataTable storeProductTable = productStoreDT.GetByCond("ProductID=" + productId + " AND StoreID = " + storeId + " AND Quantity >0 ", "OrderNum ASC", tran);
int tmpQuantity = 0;
var totalQuantity = storeProductTable.Compute("SUM(Quantity)", "");
if (Converter.ToInt32(totalQuantity) < quantity)
{
return("Lỗi: Sản phẩm trong kho không đủ để xuất");
}
else
{
foreach (DataRow row in storeProductTable.Rows)
{
LogProductexportContract productExportDTO = new LogProductexportContract();
string storeProductId = row["ID"].ToString();
tmpQuantity += Converter.ToInt32(row["Quantity"]);
if (tmpQuantity < quantity)
{
productExportDTO.Storeid = storeId;
productExportDTO.Productid = productId;
productExportDTO.Importcode = row["ImportCode"].ToString();
productExportDTO.Quantity = row["Quantity"].ToString();
productExportDTO.Exportdate = DateTime.Now.ToString("dd/MM/yyyy");
productExportDTO.Exportcode = exportCode;
productExportDTO.Importprice = row["Price"].ToString();
productExportDTO.Exportprice = productId;
productExportDT.Insert(productExportDTO, tran);
productStoreDT.Update(new string[] { "Quantity" }, new string[] { "0" }, " ID=" + storeProductId, tran);
}
else
{
int exportQuantity = Converter.ToInt32(row["Quantity"]) - (tmpQuantity - quantity);
int productStoreQuantity = Converter.ToInt32(row["Quantity"]) - exportQuantity;
productExportDTO.Storeid = storeId;
productExportDTO.Productid = productId;
productExportDTO.Importcode = row["ImportCode"].ToString();
productExportDTO.Quantity = exportQuantity.ToString();
productExportDTO.Exportdate = DateTime.Now.ToString("dd/MM/yyyy");
productExportDTO.Exportcode = exportCode;
productExportDTO.Importprice = row["Price"].ToString();
productExportDTO.Exportprice = productId;
productExportDT.Insert(productExportDTO, tran);
productStoreDT.Update(new string[] { "Quantity" }, new string[] { productStoreQuantity.ToString() }, " ID=" + storeProductId, tran);
break;
}
}
}
}
catch (Exception e)
{
throw e;
}
return("");
}
/// <summary>
/// Cập nhật thông tin đối tượng
/// </summary>
/// <param name="menu"></param>
/// <param name="tran"></param>
/// <returns></returns>
public string Update(LogProductexportContract logproductexport, SqlTransaction tran = null)
{
string query = String.Format("UPDATE " + TableName + @" SET StoreID={0},ProductID={1},ImportCode={2},Quantity={3},ExportDate=convert(datetime,{4},103),ExportCode={5},ImportPrice={6},ExportPrice={7}
WHERE ID=" + logproductexport.Id.ToString(),
(logproductexport.Storeid.Trim() != String.Empty ? logproductexport.Storeid.ToString() : "null").ToString(),
(logproductexport.Productid.Trim() != String.Empty ? logproductexport.Productid.ToString() : "null").ToString(),
(logproductexport.Importcode.Trim() != String.Empty? "N'" + SQLHelper.RejectInjection(logproductexport.Importcode.ToString()) + "'" : "null").ToString(),
(logproductexport.Quantity.Trim() != String.Empty ? logproductexport.Quantity.ToString() : "null").ToString(),
(logproductexport.Exportdate != null? "'" + SQLHelper.RejectInjection(logproductexport.Exportdate.ToString()) + "'" : "null").ToString(),
(logproductexport.Exportcode.Trim() != String.Empty? "N'" + SQLHelper.RejectInjection(logproductexport.Exportcode.ToString()) + "'" : "null").ToString(),
(logproductexport.Importprice.Trim() != String.Empty ? logproductexport.Importprice.ToString() : "null").ToString(),
(logproductexport.Exportprice.Trim() != String.Empty ? logproductexport.Exportprice.ToString() : "null").ToString());
if (tran == null)
{
DataProvider.ExecuteNonQuery(query);
}
else
{
DataProvider.ExecuteNonQueryWithTransaction(query, tran);
}
return(logproductexport.Id.ToString());
}
