110,538
社区成员
发帖
与我相关
我的任务
分享
string sQL = " select top 1 VisaInfo,MaintainDate,FixInfo from VisaInfo where LicenceNo=@LicenceNo and licenceColor=@LicenceColor order by visaInfo desc ";
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@LicenceNo", SqlDbType.VarChar, 20),
new SqlParameter("@LicenceColor", SqlDbType.VarChar, 20)
};
sqlParams[0].Value = licenceNo;
sqlParams[1].Value = licenceColor;
log.Info("获取最后签章信息,select top 1 VisaInfo,MaintainDate,FixInfo from VisaInfo where LicenceNo=" + sqlParams[0].Value + "and licenceColor=" + sqlParams[1].Value + " order by visaInfo desc");
DBClass class2 = new DBClass("ConnStr");
class2.ReadData(sQL, sqlParams);
while (class2.MyReader.Read())
{
MaintainDate = Convert.ToDateTime(class2.MyReader["MaintainDate"]).ToShortDateString();
FixInfo = class2.MyReader["FixInfo"].ToString();
VisaInfo = class2.MyReader["VisaInfo"].ToString();
flag = true;
}
class2.MyReader.Dispose();
class2.MyReader.Close();
class2.Conn.Dispose();
class2.Conn.Close();
if (!flag)
{
AlertError = "读取最后一次签章信息失败,不存在记录";
}