public int Insert(ProductBarcodeInfo oParam) { string sql = @"INSERT INTO product_barcode(ProductSysNo,Barcode) VALUES(@ProductSysNo, @Barcode)"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4); SqlParameter paramBarcode = new SqlParameter("@Barcode", SqlDbType.NVarChar, 50); if (oParam.ProductSysNo != AppConst.IntNull) { paramProductSysNo.Value = oParam.ProductSysNo; } else { paramProductSysNo.Value = System.DBNull.Value; } if (oParam.Barcode != AppConst.StringNull) { paramBarcode.Value = oParam.Barcode; } else { paramBarcode.Value = System.DBNull.Value; } cmd.Parameters.Add(paramProductSysNo); cmd.Parameters.Add(paramBarcode); return(SqlHelper.ExecuteNonQuery(cmd)); }
public int Update(ProductBarcodeInfo oParam) { string sql = @"UPDATE product_barcode SET ProductSysNo=@ProductSysNo, Barcode=@Barcode, DateStamp=@DateStamp WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4); SqlParameter paramBarcode = new SqlParameter("@Barcode", SqlDbType.NVarChar, 50); SqlParameter paramDateStamp = new SqlParameter("@DateStamp", SqlDbType.DateTime, 8); if (oParam.ProductSysNo != AppConst.IntNull) { paramProductSysNo.Value = oParam.ProductSysNo; } else { paramProductSysNo.Value = System.DBNull.Value; } if (oParam.Barcode != AppConst.StringNull) { paramBarcode.Value = oParam.Barcode; } else { paramBarcode.Value = System.DBNull.Value; } if (oParam.DateStamp != AppConst.DateTimeNull) { paramDateStamp.Value = oParam.DateStamp; } else { paramBarcode.Value = System.DBNull.Value; } cmd.Parameters.Add(paramProductSysNo); cmd.Parameters.Add(paramBarcode); cmd.Parameters.Add(paramDateStamp); return(SqlHelper.ExecuteNonQuery(cmd)); }