コード例 #1
0
        /// <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));
        }
コード例 #2
0
 /// <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);
     }
 }