chuanyin-group-project.git

			@@ -118,7 +118,7 @@
			this.txtCreatTimeend.Value,
			this.selCarId.Value,
			this.txtCreater.Value,
			this.selClockType.Value
			""
			);

			Database DC = new Database();
			@@ -128,6 +128,104 @@
			List<OA_CorporateClientsContract> fileDataList = null;
			foreach (var oA_DriverRecord in oA_DriverRecords)
			{


			var oA_DriverRecord1 = _oA_DriverRecordBLL.GetModelByTimeCarIDClockType(oA_DriverRecord.CreatTime, oA_DriverRecord.CarID, 2);
			if (oA_DriverRecord1 != null)
			{
			oA_DriverRecord1.CreatTimeName = oA_DriverRecord1.CreatTime.ToString("yyyy-MM-dd HH:mm:ss");
			if (string.IsNullOrEmpty(oA_DriverRecord1.MileageImg))
			{
			oA_DriverRecord1.MileageImgName = "";
			}
			else
			{
			oA_DriverRecord1.MileageImgName = "<img src=\"" + oA_DriverRecord1.MileageImg + "\" width=\"20\" height=\"20\" >";
			}





			string sqlStr1 = string.Format(@" select * from [dbo].[OA_attachment] where [OA_Id]='{0}' and [AttachmentType]=4 order by [CreateTime] ", oA_DriverRecord1.Id);

			SqlCommand myCmd1 = new SqlCommand(sqlStr1, DC.Connection);
			//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
			var a1 = myCmd1.ExecuteReader();
			//myDa.Dispose();
			fileDataList = new List<OA_CorporateClientsContract>();
			OA_CorporateClientsContract Contract1;
			var j = 1;
			while (a1.Read())
			{ //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿）
			Contract1 = new OA_CorporateClientsContract();
			// Contract.Keyid = a.GetInt32(0);
			//Contract.CorporateClientsid = a.GetGuid(1);
			//Contract.CorporateClientsName = a.GetString(4);
			Contract1.FileName = a1[4].ToString();
			Contract1.PageCode = j;
			Contract1.FilePath = a1.GetString(2);
			// Contract.Remark = a.GetString(6);
			j += 1;

			fileDataList.Add(Contract1);
			}
			a1.Close(); //关闭sqldatareader

			if (fileDataList.Count > 0)
			{
			oA_DriverRecord1.ZhuangcheImg = "<img src=\"" + fileDataList[0].FilePath + "\" width=\"20\" height=\"20\" >";
			}
			else
			{
			oA_DriverRecord1.ZhuangcheImg = "";
			}




			sqlStr1 = string.Format(@" select * from [dbo].[OA_attachment] where [OA_Id]='{0}' and [AttachmentType]=5 order by [CreateTime] ", oA_DriverRecord1.Id);

			myCmd1 = new SqlCommand(sqlStr1, DC.Connection);
			//SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
			a1 = myCmd1.ExecuteReader();
			//myDa.Dispose();
			fileDataList = new List<OA_CorporateClientsContract>();
			j = 1;
			while (a1.Read())
			{ //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿）
			Contract1 = new OA_CorporateClientsContract();
			// Contract.Keyid = a.GetInt32(0);
			//Contract.CorporateClientsid = a.GetGuid(1);
			//Contract.CorporateClientsName = a.GetString(4);
			Contract1.FileName = a1[4].ToString();
			Contract1.PageCode = j;
			Contract1.FilePath = a1.GetString(2);
			// Contract.Remark = a.GetString(6);
			j += 1;

			fileDataList.Add(Contract1);
			}
			a1.Close(); //关闭sqldatareader

			if (fileDataList.Count > 0)
			{
			oA_DriverRecord1.CarConditionImg = "<img src=\"" + fileDataList[0].FilePath + "\" width=\"20\" height=\"20\" >";
			}
			else
			{
			oA_DriverRecord1.CarConditionImg = "";
			}

			oA_DriverRecord.oA_DriverRecord = oA_DriverRecord1;
			}
			else
			{
			oA_DriverRecord.oA_DriverRecord = new OA_DriverRecord();
			}



			if (string.IsNullOrEmpty(oA_DriverRecord.MileageImg))
			{
			oA_DriverRecord.MileageImgName = "";
			@@ -272,7 +370,7 @@
			this.txtCreatTimeend.Value,
			this.selCarId.Value,
			this.txtCreater.Value,
			this.selClockType.Value
			""
			);

			// 创建工作簿