谢谢m2Land的回答,是应该做判断,然后设置为DBNull.Value,全部代码如下:
if (ReturnDate == Null.NullDate)
{
//ReturnDate = DBNull.Value;
//SqlHelper.ExecuteNonQuery(ConnectionString,
GetQualifiedName("gygac_DeviceDeployUpdate"), DDId, ModuleId,
DeviceName, Borrower, Lender, LendDate, Estimated, IsReturned,
System.Data.SqlTypes.SqlDateTime.MinValue, EMail, CreatedByUser,
Remark);
SqlHelper.ExecuteNonQuery(ConnectionString,
GetQualifiedName("gygac_DeviceDeployUpdate"), DDId, ModuleId,
DeviceName, Borrower, Lender, LendDate, Estimated, IsReturned,
DBNull.Value, EMail, CreatedByUser, Remark);
}
else
{
SqlHelper.ExecuteNonQuery(ConnectionString,
GetQualifiedName("gygac_DeviceDeployUpdate"), DDId, ModuleId,
DeviceName, Borrower, Lender, LendDate, Estimated, IsReturned,
ReturnDate, EMail, CreatedByUser, Remark);