/// <summary>
        /// 亮度测试更新
        /// </summary>
        /// <param name="piLD"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int updateProjectorInformation_MainTable_LDZ2Dal(ProjectorInformation_LD piLD, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = piLD.FuselageCode
                },
                new SqlParameter("@IlluminationValue", SqlDbType.VarChar, 50)
                {
                    Value = piLD.IlluminationValue
                },
                new SqlParameter("@WiredMAC", SqlDbType.VarChar, 50)
                {
                    Value = piLD.WiredMAC
                },
                new SqlParameter("@wirelessMAC", SqlDbType.VarChar, 50)
                {
                    Value = piLD.wirelessMAC
                },
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
        /// <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="FuselageCode"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public ProjectorInformation_LHH selectProjectorInformation_MainTable_LHHDal(string FuselageCode, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);
            ProjectorInformation_LHH pif = new ProjectorInformation_LHH();
            DateTime dt = new DateTime(1993, 5, 17);


            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = FuselageCode
                }
            };

            using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text, pms))
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        pif.FuselageCode       = reader.GetString(0);
                        pif.PostAgingTestTime  = reader.IsDBNull(1) ? dt : reader.GetDateTime(1);
                        pif.PostAgingTestTime2 = reader.IsDBNull(2) ? null : reader.GetDateTime(2).ToString();
                    }
                }
                return(pif);
            }
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 查询前缀表
        /// </summary>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public List <ProjectorInformation_EncodingRules> selectProjectorInformation_EncodingRulesDal(string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);
            List <ProjectorInformation_EncodingRules> list = new List <ProjectorInformation_EncodingRules>();

            try
            {
                using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            list.Add(new ProjectorInformation_EncodingRules
                            {
                                TypeName                   = reader.GetString(0),
                                Prefix_BodyCode            = reader.IsDBNull(1)?"":reader.GetString(1),
                                Prefix_OpticalCode         = reader.IsDBNull(2)?"":reader.GetString(2),
                                Prefix_MotherboardEncoding = reader.IsDBNull(3)?"":reader.GetString(3)
                            });
                        }
                    }
                    return(list);
                }
            }
            catch
            {
                throw;
            }
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 插入前缀表
        /// </summary>
        /// <param name="list"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int insertProjectorInformation_EncodingRulesDal(List <ProjectorInformation_EncodingRules> list, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@TypeName", SqlDbType.VarChar, 50)
                {
                    Value = list[0].TypeName
                },
                new SqlParameter("@Prefix_BodyCode", SqlDbType.VarChar, 50)
                {
                    Value = list[0].Prefix_BodyCode
                },
                new SqlParameter("@Prefix_OpticalCode", SqlDbType.VarChar, 50)
                {
                    Value = list[0].Prefix_OpticalCode
                },
                new SqlParameter("@Prefix_MotherboardEncoding", SqlDbType.VarChar, 50)
                {
                    Value = list[0].Prefix_MotherboardEncoding
                },
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
Ejemplo n.º 6
0
        /// <summary>
        /// 前缀订单更新表
        /// </summary>
        /// <param name="projeSelect"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int updateProjectorInformation_SelectPrefixDal(ProjectorInformation_SelectPrefix projeSelect, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@TypeName", SqlDbType.VarChar, 50)
                {
                    Value = projeSelect.TypeName
                },
                new SqlParameter("@Prefix_BodyCode", SqlDbType.VarChar, 50)
                {
                    Value = projeSelect.Prefix_BodyCode
                },
                new SqlParameter("@Prefix_OpticalCode", SqlDbType.VarChar, 50)
                {
                    Value = projeSelect.Prefix_OpticalCode
                },
                new SqlParameter("@Prefix_MotherboardEncoding", SqlDbType.VarChar, 50)
                {
                    Value = projeSelect.Prefix_MotherboardEncoding
                },
                new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50)
                {
                    Value = projeSelect.ZhiDan
                },
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
        /// <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));
        }
Ejemplo n.º 8
0
        public ProjectorInformation_SelectPrefix selecctProjectorInformation_SelectPrefixDal(string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);
            ProjectorInformation_SelectPrefix projeSelect = new ProjectorInformation_SelectPrefix();

            try
            {
                using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            projeSelect.TypeName                   = reader.GetString(0);
                            projeSelect.Prefix_BodyCode            = reader.IsDBNull(1) ? "" : reader.GetString(1);
                            projeSelect.Prefix_OpticalCode         = reader.IsDBNull(2) ? "" : reader.GetString(2);
                            projeSelect.Prefix_MotherboardEncoding = reader.IsDBNull(3) ? "" : reader.GetString(3);
                            projeSelect.ZhiDan = reader.IsDBNull(4) ? "" : reader.GetString(4);
                        }
                    }
                    return(projeSelect);
                }
            }
            catch
            {
                throw;
            }
        }
Ejemplo n.º 9
0
        /// <summary>
        /// 主板表查询是否存在主板编码
        /// </summary>
        /// <param name="MainBoardCode"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int selectCountProjectorInformation_MainBoardDal(string MainBoardCode, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50)
                {
                    Value = MainBoardCode
                }
            };

            return((int)SQLhelp.ExecuteScalar(sql, CommandType.Text, pms));
        }
        /// <summary>
        /// 查询登录密码
        /// </summary>
        /// <param name="txt_Password"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int selectCountProjectorInformation_AdminiDal(string txt_Password, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@AdminiPassword", SqlDbType.VarChar, 50)
                {
                    Value = txt_Password
                }
            };

            return((int)SQLhelp.ExecuteScalar(sql, CommandType.Text, pms));
        }
        /// <summary>
        /// 按机身码删除数据
        /// </summary>
        /// <param name="FuselageCode"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int deleteProjectorInformation_MainTableFuselageCodeDal(string FuselageCode, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = FuselageCode
                }
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
        /// <summary>
        /// 老化前测试更新
        /// </summary>
        /// <param name="FuselageCode"></param>
        /// <param name="PreAgingTestTime"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int updateProjectorInformation_MainTable_LHQDal(string FuselageCode, DateTime PreAgingTestTime, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = FuselageCode
                },
                new SqlParameter("@PreAgingTestTime", SqlDbType.DateTime)
                {
                    Value = PreAgingTestTime
                }
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
        /// <summary>
        /// 查询有没有存在机身编码
        /// </summary>
        /// <param name="FuselageCode"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int selectCountProjectorInformation_MainTableDal(string FuselageCode, string ZhiDan, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = FuselageCode
                },
                new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50)
                {
                    Value = ZhiDan
                }
            };

            return((int)SQLhelp.ExecuteScalar(sql, CommandType.Text, pms));
        }
        /// <summary>
        /// 老化下架时间更新
        /// </summary>
        /// <param name="lhx"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int updateProjectorInformation_MainTable_LHXDal(ProjectorInformation_LHX lhx, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = lhx.FuselageCode
                },
                new SqlParameter("@AgeingEndTime", SqlDbType.DateTime)
                {
                    Value = lhx.AgeingEndTime
                }
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
        /// <summary>
        /// 老化后插入数据
        /// </summary>
        /// <param name="proje"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int insertProjectorInformation_MainTable_LHHDal(ProjectorInformation_LHH proje, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = proje.FuselageCode
                },
                new SqlParameter("@PostAgingTestTime", SqlDbType.DateTime)
                {
                    Value = proje.PostAgingTestTime
                }
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
Ejemplo n.º 16
0
        /// <summary>
        /// 主板表更新数据
        /// </summary>
        /// <param name="proje"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int updateProjectorInformation_MainBoardDal(ProjectorInformation_MainBoard proje, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50)
                {
                    Value = proje.MainBoardCode
                },
                new SqlParameter("@MainBoardTime", SqlDbType.DateTime)
                {
                    Value = proje.MainBoardTime
                }
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
        /// <summary>
        /// 包装更新
        /// </summary>
        /// <param name="piBZ"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int updateProjectorInformation_MainTable_BZDal(ProjectorInformation_BZ piBZ, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = piBZ.FuselageCode
                },
                new SqlParameter("@PackingTime", SqlDbType.VarChar, 500)
                {
                    Value = piBZ.PackingTime
                }
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
Ejemplo n.º 18
0
        public int updateProjectorInformation_MACDal(ProjectorInformation_MAC pmac, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@MAC", SqlDbType.VarChar, 80)
                {
                    Value = pmac.MAC
                },
                new SqlParameter("@selectedTab", SqlDbType.VarChar, 50)
                {
                    Value = pmac.selectedTab
                },
                new SqlParameter("@LHSX", SqlDbType.Bit)
                {
                    Value = pmac.LHSX
                }
            };

            return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
        }
Ejemplo n.º 19
0
        public List <ProjectorInformation_MAC> selectProjectorInformation_MAC(string MAC, string SQLCommand)
        {
            string sql = SQLhelp.GetSQLCommand(SQLCommand);
            List <ProjectorInformation_MAC> list = new List <ProjectorInformation_MAC>();

            SqlParameter[] pms = new SqlParameter[]
            {
                new SqlParameter("@MAC", SqlDbType.VarChar, 80)
                {
                    Value = MAC
                }
            };
            try
            {
                using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text, pms))
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            list.Add(new ProjectorInformation_MAC()
                            {
                                MAC         = reader.GetString(0),
                                selectedTab = reader.GetString(1),
                                LHSX        = reader.GetBoolean(2)
                            });
                        }
                    }
                    return(list);
                }
            }
            catch
            {
                throw;
            }
        }
        /// <summary>
        /// 主表按机身码查询
        /// </summary>
        /// <param name="FuselageCode"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public List <ProjectorInformation_MainTable_STR> selectProjectorInformation_MainTableDal(string FuselageCode, string ZhiDan, string OpticalCode, string MainBoardCode, string WiredMAC, string wirelessMAC, string SQLCommand)
        {
            StringBuilder sql = new StringBuilder(SQLhelp.GetSQLCommand(SQLCommand));

            List <ProjectorInformation_MainTable_STR> list = new List <ProjectorInformation_MainTable_STR>();
            List <SqlParameter> listsqlpar = new List <SqlParameter>();
            List <string>       wherelist  = new List <string>();

            if (FuselageCode.Length > 0)
            {
                wherelist.Add(" FuselageCode=@FuselageCode ");
                listsqlpar.Add(new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = FuselageCode
                });
            }
            if (ZhiDan.Length > 0)
            {
                wherelist.Add(" ZhiDan=@ZhiDan ");
                listsqlpar.Add(new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50)
                {
                    Value = ZhiDan
                });
            }
            if (OpticalCode.Length > 0)
            {
                wherelist.Add(" OpticalCode=@OpticalCode ");
                listsqlpar.Add(new SqlParameter("@OpticalCode", SqlDbType.VarChar, 80)
                {
                    Value = OpticalCode
                });
            }
            if (MainBoardCode.Length > 0)
            {
                wherelist.Add(" MainBoardCode=@MainBoardCode ");
                listsqlpar.Add(new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50)
                {
                    Value = MainBoardCode
                });
            }
            if (WiredMAC.Length > 0)
            {
                wherelist.Add(" WiredMAC=@WiredMAC ");
                listsqlpar.Add(new SqlParameter("@WiredMAC", SqlDbType.VarChar, 50)
                {
                    Value = WiredMAC
                });
            }
            if (wirelessMAC.Length > 0)
            {
                wherelist.Add(" wirelessMAC=@wirelessMAC ");
                listsqlpar.Add(new SqlParameter("@wirelessMAC", SqlDbType.VarChar, 50)
                {
                    Value = wirelessMAC
                });
            }

            if (wherelist.Count > 0)
            {
                sql.Append(" where ");
                sql.Append(string.Join(" and ", wherelist));
            }

            try
            {
                if (listsqlpar.Count > 0)
                {
                    using (SqlDataReader reader = SQLhelp.ExecuteReader(sql.ToString(), CommandType.Text, listsqlpar.ToArray()))
                    {
                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                list.Add(new ProjectorInformation_MainTable_STR()
                                {
                                    FuselageCode         = reader.GetString(0),
                                    OpticalCode          = reader.IsDBNull(1) ? "" : reader.GetString(1),
                                    PolishingMachineTime = reader.IsDBNull(2) ? "" : reader.GetDateTime(2).ToString(),
                                    PreAgingTestTime     = reader.IsDBNull(3) ? "" : reader.GetDateTime(3).ToString(),
                                    AgeingBeginTime      = reader.IsDBNull(4) ? "" : reader.GetDateTime(4).ToString(),
                                    AgeingEndTime        = reader.IsDBNull(5) ? "" : reader.GetDateTime(5).ToString(),
                                    PostAgingTestTime    = reader.IsDBNull(6) ? "" : reader.GetDateTime(6).ToString(),
                                    PreAgingTestTime2    = reader.IsDBNull(7) ? "" : reader.GetDateTime(7).ToString(),
                                    PostAgingTestTime2   = reader.IsDBNull(8) ? "" : reader.GetDateTime(8).ToString(),
                                    IlluminationValue    = reader.IsDBNull(9) ? "" : reader.GetString(9),
                                    WiredMAC             = reader.IsDBNull(10) ? "" : reader.GetString(10),
                                    wirelessMAC          = reader.IsDBNull(11) ? "" : reader.GetString(11),
                                    LuminanceTestTime    = reader.IsDBNull(12) ? "" : reader.GetDateTime(12).ToString(),
                                    RepairText           = reader.IsDBNull(13) ? "" : reader.GetString(13),
                                    RepairTime           = reader.IsDBNull(14) ? "" : reader.GetDateTime(14).ToString(),
                                    PackingTime          = reader.IsDBNull(15) ? "" : reader.GetDateTime(15).ToString(),
                                    MainBoardCode        = reader.IsDBNull(16) ? "" : reader.GetString(16),
                                    MainBoardTime        = reader.IsDBNull(17) ? "" : reader.GetDateTime(17).ToString(),
                                    ZhiDan = reader.IsDBNull(18) ? "" : reader.GetString(18),
                                    AfterMaintenanceOpticalCode   = reader.IsDBNull(19)?"":reader.GetString(19),
                                    AfterMaintenanceMainBoardCode = reader.IsDBNull(20)?"":reader.GetString(20),
                                    LuminanceTestQTime            = reader.IsDBNull(21) ? "" : reader.GetDateTime(21).ToString(),
                                });
                            }
                        }
                        return(list);
                    }
                }
                else
                {
                    using (SqlDataReader reader = SQLhelp.ExecuteReader(sql.ToString(), CommandType.Text))
                    {
                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                list.Add(new ProjectorInformation_MainTable_STR()
                                {
                                    FuselageCode         = reader.GetString(0),
                                    OpticalCode          = reader.IsDBNull(1) ? "" : reader.GetString(1),
                                    PolishingMachineTime = reader.IsDBNull(2) ? "" : reader.GetDateTime(2).ToString(),
                                    PreAgingTestTime     = reader.IsDBNull(3) ? "" : reader.GetDateTime(3).ToString(),
                                    AgeingBeginTime      = reader.IsDBNull(4) ? "" : reader.GetDateTime(4).ToString(),
                                    AgeingEndTime        = reader.IsDBNull(5) ? "" : reader.GetDateTime(5).ToString(),
                                    PostAgingTestTime    = reader.IsDBNull(6) ? "" : reader.GetDateTime(6).ToString(),
                                    PreAgingTestTime2    = reader.IsDBNull(7) ? "" : reader.GetDateTime(7).ToString(),
                                    PostAgingTestTime2   = reader.IsDBNull(8) ? "" : reader.GetDateTime(8).ToString(),
                                    IlluminationValue    = reader.IsDBNull(9) ? "" : reader.GetString(9),
                                    WiredMAC             = reader.IsDBNull(10) ? "" : reader.GetString(10),
                                    wirelessMAC          = reader.IsDBNull(11) ? "" : reader.GetString(11),
                                    LuminanceTestTime    = reader.IsDBNull(12) ? "" : reader.GetDateTime(12).ToString(),
                                    RepairText           = reader.IsDBNull(13) ? "" : reader.GetString(13),
                                    RepairTime           = reader.IsDBNull(14) ? "" : reader.GetDateTime(14).ToString(),
                                    PackingTime          = reader.IsDBNull(15) ? "" : reader.GetDateTime(15).ToString(),
                                    MainBoardCode        = reader.IsDBNull(16) ? "" : reader.GetString(16),
                                    MainBoardTime        = reader.IsDBNull(17) ? "" : reader.GetDateTime(17).ToString(),
                                    ZhiDan = reader.IsDBNull(18) ? "" : reader.GetString(18),
                                    AfterMaintenanceOpticalCode   = reader.IsDBNull(19) ? "" : reader.GetString(19),
                                    AfterMaintenanceMainBoardCode = reader.IsDBNull(20) ? "" : reader.GetString(20),
                                    LuminanceTestQTime            = reader.IsDBNull(21) ? "" : reader.GetDateTime(21).ToString(),
                                });
                            }
                        }
                        return(list);
                    }
                }
            }
            catch
            {
                throw;
            }
        }
        /// <summary>
        /// 多条件删除
        /// </summary>
        /// <param name="FuselageCode"></param>
        /// <param name="ZhiDan"></param>
        /// <param name="OpticalCode"></param>
        /// <param name="MainBoardCode"></param>
        /// <param name="WiredMAC"></param>
        /// <param name="wirelessMAC"></param>
        /// <param name="SQLCommand"></param>
        /// <returns></returns>
        public int deleteProjectorInformation_MainTableDal(string FuselageCode, string ZhiDan, string OpticalCode, string MainBoardCode, string WiredMAC, string wirelessMAC, string SQLCommand)
        {
            StringBuilder sql = new StringBuilder(SQLhelp.GetSQLCommand(SQLCommand));

            List <SqlParameter> listsqlpar = new List <SqlParameter>();
            List <string>       wherelist  = new List <string>();

            if (FuselageCode.Length > 0)
            {
                wherelist.Add(" FuselageCode=@FuselageCode ");
                listsqlpar.Add(new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
                {
                    Value = FuselageCode
                });
            }
            if (ZhiDan.Length > 0)
            {
                wherelist.Add(" ZhiDan=@ZhiDan ");
                listsqlpar.Add(new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50)
                {
                    Value = ZhiDan
                });
            }
            if (OpticalCode.Length > 0)
            {
                wherelist.Add(" OpticalCode=@OpticalCode ");
                listsqlpar.Add(new SqlParameter("@OpticalCode", SqlDbType.VarChar, 80)
                {
                    Value = OpticalCode
                });
            }
            if (MainBoardCode.Length > 0)
            {
                wherelist.Add(" MainBoardCode=@MainBoardCode ");
                listsqlpar.Add(new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50)
                {
                    Value = MainBoardCode
                });
            }
            if (WiredMAC.Length > 0)
            {
                wherelist.Add(" WiredMAC=@WiredMAC ");
                listsqlpar.Add(new SqlParameter("@WiredMAC", SqlDbType.VarChar, 50)
                {
                    Value = WiredMAC
                });
            }
            if (wirelessMAC.Length > 0)
            {
                wherelist.Add(" wirelessMAC=@wirelessMAC ");
                listsqlpar.Add(new SqlParameter("@wirelessMAC", SqlDbType.VarChar, 50)
                {
                    Value = wirelessMAC
                });
            }

            if (wherelist.Count > 0)
            {
                sql.Append(" where ");
                sql.Append(string.Join(" and ", wherelist));
            }

            if (listsqlpar.Count > 0)
            {
                return(SQLhelp.ExecuteNonQuery(sql.ToString(), CommandType.Text, listsqlpar.ToArray()));
            }
            else
            {
                return(SQLhelp.ExecuteNonQuery(sql.ToString(), CommandType.Text));
            }
        }