/// <summary>
/// 维修更新
/// </summary>
/// <param name="piWX"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_MainTable_WXDal(ProjectorInformation_WX piWX, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = piWX.FuselageCode
},
new SqlParameter("@RepairText", SqlDbType.VarChar, 500)
{
Value = "++" + piWX.RepairText
},
new SqlParameter("@RepairTime", SqlDbType.DateTime)
{
Value = piWX.RepairTime
},
new SqlParameter("@AfterMaintenanceOpticalCode", SqlDbType.VarChar, 80)
{
Value = piWX.AfterMaintenanceOpticalCode
},
new SqlParameter("@AfterMaintenanceMainBoardCode", SqlDbType.VarChar, 50)
{
Value = piWX.AfterMaintenanceMainBoardCode
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 维修更新
/// </summary>
/// <param name="piWX"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public bool updateProjectorInformation_MainTable_WXBll(ProjectorInformation_WX piWX, string SQLCommand)
{
if (pmtd.updateProjectorInformation_MainTable_WXDal(piWX, SQLCommand) > 0)
{
return(true);
}
else
{
return(false);
}
}