public void SendLendingInfoTest() { // string ConnectionString = string.Empty; // TODO: 初始化为适当的值 DBLendingInfoDetail target = new DBLendingInfoDetail(connstr); // TODO: 初始化为适当的值 string TrainmanGUID = string.Empty; // TODO: 初始化为适当的值 string remark = string.Empty; // TODO: 初始化为适当的值 List <LendingInfoDetail> lifd = null; // TODO: 初始化为适当的值 lifd = new List <LendingInfoDetail>(); LendingInfoDetail lendinfo = new LendingInfoDetail(); //定义他的值 TrainmanGUID = "08809D42-3B1C-4318-B818-756A7ED04300"; lendinfo.dtBorrwoTime = DateTime.Now; lendinfo.nBorrowVerifyType = 1; lendinfo.strTrainmanGUID = TrainmanGUID; lendinfo.strLenderGUID = "02517596-577B-4A0C-9E7F-A8C1AA35888E"; lendinfo.strLendingInfoGUID = Guid.NewGuid().ToString(); lendinfo.nLendingType = 1; lendinfo.strLendingExInfo = 450; lendinfo.nReturnState = 0; lendinfo.dtModifyTime = DateTime.Now; lifd.Add(lendinfo); target.SendLendingInfo(TrainmanGUID, remark, lifd); Assert.IsNotNull(lifd); // Assert.Inconclusive("无法验证不返回值的方法。"); }
/// <summary> ///GetTrainmanNotReturnLendingInfo_DRToModelDTToList 的测试 ///</summary> // [Test] public void GetTrainmanNotReturnLendingInfo_DRToModelDTToListTest() { // string ConnectionString = string.Empty; // TODO: 初始化为适当的值 DBLendingInfoDetail target = new DBLendingInfoDetail(connstr); // TODO: 初始化为适当的值 DataRow dr = null; // TODO: 初始化为适当的值 LendingInfoDetail expected = null; // TODO: 初始化为适当的值 LendingInfoDetail actual; actual = target.GetTrainmanNotReturnLendingInfo_DRToModelDTToList(dr); Assert.AreEqual(expected, actual); // Assert.Inconclusive("验证此测试方法的正确性。"); }
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(ConnectionString, CommandType.Text, strSQL.ToString()).Tables[0].Rows.Count > 0); }
public void GiveBackDetailTest() { // string ConnectionString = string.Empty; // TODO: 初始化为适当的值 DBLendingInfoDetail target = new DBLendingInfoDetail(connstr); // TODO: 初始化为适当的值 List <LendingInfoDetail> lifd = null; // TODO: 初始化为适当的值 lifd = new List <LendingInfoDetail>(); LendingInfoDetail l = new LendingInfoDetail(); l.nGiveBackVerifyType = 0; l.strGiveBackTrainmanGUID = "55E0BDC7-CCD4-4979-BA69-D890F814F08D"; l.strGUID = "25416FBC-35E7-40E4-B881-6C2314D4C08D"; lifd.Add(l); target.GiveBackDetail(lifd); Assert.IsNotNull(lifd); // Assert.Inconclusive("无法验证不返回值的方法。"); }
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(ConnectionString, 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 void CheckLendAbleTest() { // string ConnectionString = string.Empty; // TODO: 初始化为适当的值 DBLendingInfoDetail target = new DBLendingInfoDetail(connstr); // TODO: 初始化为适当的值 LendingInfoDetail newmodel = null; // TODO: 初始化为适当的值 string strWorkShop = string.Empty; // TODO: 初始化为适当的值 strWorkShop = "3b50bf66-dabb-48c0-8b6d-05db80591090"; newmodel = new LendingInfoDetail(); newmodel.dtBorrwoTime = DateTime.Today; newmodel.dtModifyTime = DateTime.Today; newmodel.nBorrowVerifyType = 0; newmodel.nKeepMunites = 20; newmodel.nLendingType = 0; newmodel.nReturnState = 1; newmodel.strBorrowVerifyTypeName = "1"; newmodel.strGiveBackTrainmanGUID = "08809D42-3B1C-4318-B818-756A7ED04300"; newmodel.strGiveBackTrainmanName = "张勇"; newmodel.strGiveBackTrainmanNumber = "2300679"; newmodel.strGiveBackVerifyTypeName = "1"; newmodel.strGUID = Guid.NewGuid().ToString(); newmodel.strLenderGUID = ""; newmodel.strLenderName = ""; newmodel.strLenderNumber = ""; newmodel.strLendingExInfo = 420; newmodel.strLendingInfoGUID = ""; newmodel.strLendingTypeAlias = ""; newmodel.strLendingTypeName = ""; newmodel.strStateName = ""; newmodel.strTrainmanGUID = "08809D42-3B1C-4318-B818-756A7ED04300"; newmodel.strTrainmanName = "张勇"; newmodel.strTrainmanNumber = "2300679"; newmodel.strWorkShopGUID = "3b50bf66-dabb-48c0-8b6d-05db80591090"; strWorkShop = "3b50bf66-dabb-48c0-8b6d-05db80591090"; bool expected = true; // TODO: 初始化为适当的值 bool actual; actual = target.CheckLendAble(newmodel, strWorkShop); Assert.AreEqual(expected, actual); // Assert.Inconclusive("验证此测试方法的正确性。"); }
public void AddLendingDetailsTest() { // string ConnectionString = string.Empty; // TODO: 初始化为适当的值 DBLendingInfoDetail target = new DBLendingInfoDetail(connstr); // TODO: 初始化为适当的值 List <LendingInfoDetail> lifd = null; // TODO: 初始化为适当的值 lifd = new List <LendingInfoDetail>(); LendingInfoDetail newmodel = new LendingInfoDetail(); newmodel.dtBorrwoTime = DateTime.Today; newmodel.dtModifyTime = DateTime.Today; newmodel.nBorrowVerifyType = 0; newmodel.nKeepMunites = 20; newmodel.nLendingType = 0; newmodel.nReturnState = 1; newmodel.strBorrowVerifyTypeName = "1"; newmodel.strGiveBackTrainmanGUID = "08809D42-3B1C-4318-B818-756A7ED04300"; newmodel.strGiveBackTrainmanName = "张勇"; newmodel.strGiveBackTrainmanNumber = "2300679"; newmodel.strGiveBackVerifyTypeName = "1"; newmodel.strGUID = Guid.NewGuid().ToString(); newmodel.strLenderGUID = ""; newmodel.strLenderName = ""; newmodel.strLenderNumber = ""; newmodel.strLendingExInfo = 420; newmodel.strLendingInfoGUID = ""; newmodel.strLendingTypeAlias = ""; newmodel.strLendingTypeName = ""; newmodel.strStateName = ""; newmodel.strTrainmanGUID = "08809D42-3B1C-4318-B818-756A7ED04300"; newmodel.strTrainmanName = "张勇"; newmodel.strTrainmanNumber = "2300679"; newmodel.strWorkShopGUID = "3b50bf66-dabb-48c0-8b6d-05db80591090"; lifd.Add(newmodel); target.AddLendingDetails(lifd); Assert.IsNotNull(lifd); //Assert.Inconclusive("无法验证不返回值的方法。"); }
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); }