/// <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); } }