public bool ChangeProductStatusforOutInventory(string productID)
{
try
{
int result = int.Parse(SQLiteHelper.ExecuteNonQuery(ConfigManager.GetDBConnectString(ConfigManager.GetCurrentDBType()),
sqlUpdateOutInventory
, new object[1]
{
productID
}).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(SQLiteHelper.ExecuteNonQuery(ConfigManager.GetDBConnectString(ConfigManager.GetCurrentDBType()),
sqlInsertOutInventory
, new object[2]
{
datetime
, productID
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("插入数据时出现错误：" + ex.Message);
}
return(false);
}
public bool DeleteOrderInfo()
{
try
{
int result = int.Parse(SQLiteHelper.ExecuteNonQuery(ConfigManager.GetDBConnectString(ConfigManager.GetCurrentDBType()),
sqlDeleteRemoveOrderInfo
, null).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("删除数据时出现错误：" + ex.Message);
}
return(false);
}
public bool DeleteBorrowInfo(string DEPARTMENT_ID, string BORROWER_ID)
{
try
{
int result = int.Parse(SQLiteHelper.ExecuteNonQuery(ConfigManager.GetDBConnectString(ConfigManager.GetCurrentDBType()),
sqlDeleteRemoveBorrowInfo
, new object[2]
{
DEPARTMENT_ID, BORROWER_ID
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("删除数据时出现错误：" + ex.Message);
}
return(false);
}
public bool AddBorrowInfo(
string DOCUMENT_ID, string CREATE_DATE, string TAG_ID, string BORROWER_ID, string COMMENT)
{
try
{
int result = int.Parse(SQLiteHelper.ExecuteNonQuery(ConfigManager.GetDBConnectString(ConfigManager.GetCurrentDBType()),
sqlInsertAddBorrowInfo
, new object[5]
{
DOCUMENT_ID
, CREATE_DATE
, TAG_ID
, BORROWER_ID
, COMMENT
}).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(SQLiteHelper.ExecuteNonQuery(ConfigManager.GetDBConnectString(ConfigManager.GetCurrentDBType()),
sqlSelectGetEpc
, new object[1]
{
epc
}).ToString());
if (result > 0)
{
return(true);
}
}
catch (System.Exception ex)
{
MessageBox.Show("查询数据时出现错误：" + ex.Message);
}
return(false);
}