public bool CheckLendAble(LendingInfoDetail lifd, string strWorkShop)
{
if (lifd.strLendingExInfo == 0)
{
return(true);
}
string strSQL = "select TAB_LendingDetail.nid,TAB_Org_Trainman.strWorkShopGUID ";
strSQL += " from TAB_LendingDetail Left Join TAB_Org_Trainman On ";
strSQL += " TAB_LendingDetail.strBorrowTrainmanGUID = Tab_Org_Trainman.strTrainmanGUID ";
strSQL += " where strWorkShopGUID = '" + strWorkShop + "' and strLendingExInfo = " + lifd.strLendingExInfo + " and nReturnState = 0 and nLendingType = " + lifd.nLendingType + "";
return(SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSQL.ToString()).Tables[0].Rows.Count > 0);
}
public bool CheckReturnAble(string TrainmanGUID, LendingInfoDetail lifd)
{
string strSQL = "select * from View_LendingInfoDetail where strBorrowTrainmanGUID = ";
strSQL += " '" + TrainmanGUID + "' and nReturnState = 0 and nLendingType = " + lifd.nLendingType + " and strLendingExInfo = " + lifd.strLendingExInfo + " ";
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSQL.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
lifd.strGUID = dt.Rows[0]["strGUID"].ToString();
lifd.strLendingInfoGUID = dt.Rows[0]["strLendingInfoGUID"].ToString();
return(true);
}
else
{
return(false);
}
}
public LendingInfoDetail GetTrainmanNotReturnLendingInfo_DRToModelDTToList(DataRow dr)
{
LendingInfoDetail model = new LendingInfoDetail();
if (dr != null)
{
model.strLendingInfoGUID = ObjectConvertClass.static_ext_string(dr["strLendingInfoGUID"]);
model.nLendingType = ObjectConvertClass.static_ext_int(dr["nLendingType"]);
model.strLendingExInfo = ObjectConvertClass.static_ext_int(dr["strLendingExInfo"]);
model.nReturnState = ObjectConvertClass.static_ext_int(dr["nReturnState"]);
model.dtModifyTime = ObjectConvertClass.static_ext_date(dr["dtModifyTime"]);
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.dtBorrwoTime = ObjectConvertClass.static_ext_date(dr["dtBorrowTime"]);
model.dtGiveBackTime = ObjectConvertClass.static_ext_date(dr["dtGiveBackTime"]);
model.nBorrowVerifyType = ObjectConvertClass.static_ext_int(dr["nBorrowLoginType"]);
model.nGiveBackVerifyType = ObjectConvertClass.static_ext_int(dr["nGiveBackLoginType"]);
model.strLenderGUID = ObjectConvertClass.static_ext_string(dr["strLenderGUID"]);
model.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strBorrowTrainmanGUID"]);
model.strGiveBackTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strGiveBackTrainmanGUID"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strBorrowTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strBorrowTrainmanName"]);
model.strLenderNumber = ObjectConvertClass.static_ext_string(dr["strLenderNumber"]);
model.strLenderName = ObjectConvertClass.static_ext_string(dr["strLenderName"]);
model.strGiveBackTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strGiveBackTrainmanNumber"]);
model.strGiveBackTrainmanName = ObjectConvertClass.static_ext_string(dr["strGiveBackTrainmanName"]);
model.strBorrowVerifyTypeName = ObjectConvertClass.static_ext_string(dr["strBorrowLoginTypeName"]);
model.strGiveBackVerifyTypeName = ObjectConvertClass.static_ext_string(dr["strGiveBackLoginTypeName"]);
model.strLendingTypeName = ObjectConvertClass.static_ext_string(dr["strLendingTypeName"]);
model.strLendingTypeAlias = ObjectConvertClass.static_ext_string(dr["strAlias"]);
model.strStateName = ObjectConvertClass.static_ext_string(dr["strStateName"]);
model.nKeepMunites = ObjectConvertClass.static_ext_int(dr["nMinutes"]);
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
}
return(model);
}