/// <summary> /// 打光机更新 /// </summary> /// <param name="pdg"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public int updateProjectorInformation_MainTableDal(ProjectorInformation_DG pdg, string SQLCommand) { string sql = SQLhelp.GetSQLCommand(SQLCommand); SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@OpticalCode", SqlDbType.VarChar, 80) { Value = pdg.OpticalCode }, new SqlParameter("@PolishingMachineTime", SqlDbType.DateTime) { Value = pdg.PolishingMachineTime }, new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80) { Value = pdg.FuselageCode }, new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50) { Value = pdg.MainBoardCode }, new SqlParameter("@MainBoardTime", SqlDbType.DateTime) { Value = pdg.MainBoardTime }, new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50) { Value = pdg.ZhiDan } }; return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms)); }
/// <summary> /// 打光机更新 /// </summary> /// <param name="pdg"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public bool updateProjectorInformation_MainTableBll(ProjectorInformation_DG pdg, string SQLCommand) { if (pmtd.updateProjectorInformation_MainTableDal(pdg, SQLCommand) > 0) { return(true); } else { return(false); } }