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; } }
/// <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="projeSelect"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public bool updateProjectorInformation_SelectPrefixBll(ProjectorInformation_SelectPrefix projeSelect, string SQLCommand) { if (projeSelectDal.updateProjectorInformation_SelectPrefixDal(projeSelect, SQLCommand) > 0) { return(true); } else { return(false); } }
ProjectorInformation_SelectPrefix GetProjectorInformation_SelectPrefix(ProjectorInformation_EncodingRules projeEncoding) { ProjectorInformation_SelectPrefix projeSelect = new ProjectorInformation_SelectPrefix(); projeSelect.TypeName = projeEncoding.TypeName; projeSelect.Prefix_BodyCode = projeEncoding.Prefix_BodyCode; projeSelect.Prefix_OpticalCode = projeEncoding.Prefix_OpticalCode; projeSelect.Prefix_MotherboardEncoding = projeEncoding.Prefix_MotherboardEncoding; projeSelect.ZhiDan = this.ZhiDan; return(projeSelect); }