public bool AddProductItem(string productID, string productName
, string produceDate, string productCategory
, string descript)
{
try
{
int result = int.Parse(DbOperate.ExecuteNonQuery(SqlInsertItem
, new object[5]
{
productID
, productName
, produceDate
, productCategory
, descript
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("添加数据时出现错误：" + ex.Message);
}
return(false);
}
public bool DeleteOrderInfo()
{
try
{
int result = int.Parse(DbOperate.ExecuteNonQuery(
sqlDeleteRemoveOrderInfo
, null).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("删除数据时出现错误：" + ex.Message);
}
return(false);
}
public bool DeleteProductItem(string productID)
{
try
{
int result = int.Parse(DbOperate.ExecuteNonQuery(sqlDelete
, new object[1]
{
productID
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("删除数据时出现错误：" + ex.Message);
}
return(false);
}
public bool SetProductInStorage(string productID)
{
try
{
int result = int.Parse(DbOperate.ExecuteNonQuery(
sqlUpdateChangeStorageStatusToInStorage
, new object[1]
{
productID
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("入库时出现错误：" + ex.Message);
}
return(false);
}
public bool CheckEpcExist(string epc)
{
try
{
int result = int.Parse(DbOperate.ExecuteNonQuery(
sqlSelectGetEpc
, new object[1]
{
epc
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("查询数据时出现错误：" + ex.Message);
}
return(false);
}
public bool ChangeProductStatusforOutInventory(string productID)
{
try
{
int result = int.Parse(DbOperate.ExecuteNonQuery(
sqlUpdateOutInventory
, new object[1]
{
productID
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("删除数据时出现错误：" + ex.Message);
}
return(false);
}
public bool AddOrderItem(string productName, int productQuantity)
{
try
{
int result = int.Parse(DbOperate.ExecuteNonQuery(
sqlInsertAddOrderItem
, new object[2]
{
productName
, productQuantity
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("添加订单项时出现错误：" + ex.Message);
}
return(false);
}
public bool InsertProductInfoIntoOutInventory(string productID, string datetime)
{
try
{
int result = int.Parse(DbOperate.ExecuteNonQuery(
sqlInsertOutInventory
, new object[2]
{
datetime
, productID
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("插入数据时出现错误：" + ex.Message);
}
return(false);
}