private void GenToolRorrRetRecord(ToolsState stateOfTool, string strTime, string strEpc, string strToolType, string strToolName, string strToolID)
{
// 记录 和 事件显示
commonCls.NewToolBorrowRet(stateOfTool, strTime, strEpc, strToolType, strToolName, strToolID, strOpenUser);
if (NewEventShowEvent != null)
{
string strContent = "";
if (stateOfTool == ToolsState.借出)
{
strContent = stateOfTool.ToString();
}
else if (stateOfTool == ToolsState.在库)
{
strContent = EventContent.归还.ToString();
}
NewEventShowEvent(new NewEventEventArgs(EventType.工具借还, strToolID, strContent, strOpenUser, "", DateTime.Now));
}
}
/// <summary>
/// 工具借还记录
/// </summary>
public void NewToolBorrowRet(ToolsState state, string strTime, string strEpc, string strToolType, string strToolName, string strToolID, string strUser)
{
if (state == ToolsState.借出)
{
string strSql = strSql = "update tb_Tools set IsInStore='" + state.ToString() + "',BorrowReturnTime='" + strTime + "' where RFIDCoding='" + strEpc + "' ";
datalogic.SqlComNonQuery(strSql);
//tb_RecordBorrow ID ToolType ToolName ToolID RFIDCoding PeopleBorrow BorrowTime PeopleReturn ReturnTime BorrowDuration
strSql = "insert into tb_RecordBorrow (ToolType,ToolName,ToolID,RFIDCoding,PeopleBorrow,BorrowTime,PeopleReturn,ReturnTime,BorrowDuration)" +
"values ('" + strToolType + "','" + strToolName + "','" + strToolID + "','" + strEpc + "','" + strUser + "','" + strTime + "'," +
"'','','')";
datalogic.SqlComNonQuery(strSql);
}
else if (state == ToolsState.在库)
{
string strSql = strSql = "update tb_Tools set IsInStore='" + state + "',BorrowReturnTime='" + strTime + "' where RFIDCoding='" + strEpc + "' ";
datalogic.SqlComNonQuery(strSql);
strSql = "update tb_RecordBorrow set PeopleReturn='" + strUser + "',ReturnTime='" + strTime + "'," +
"BorrowDuration='' where RFIDCoding='" + strEpc + "' and ReturnTime='' ";
datalogic.SqlComNonQuery(strSql);
}
}
